mid-size ms sql database design w/ frontend, scripts and advanced search functions (411300)

**Strategic Claims Database Proposal** The location of our shared MS SQL host is below [login to view URL] ***Note:** This is the smaller and first of two projects we have in the works. Whoever completes this project for us will be in an excellent position to receive the contract for our second much larger and more important project. **What we have**: We already have a shared and hosted MS SQL database with an online provider, and we have our data in excel spreadsheet and/or MS Access format. **What we need in summary** A web based application with a simple, no-frills GUI that allows users to search two different databases. Users can create custom search criteria, and save them as a custom query for later use. Users can also create custom reports, which present information captured from the databases in static format, and generate graphs, averages, lists, and other simple financial or mathematical calculations. The Administrator level users can organize users into groups, and control what each user is able to see and do (which fields are visible and/or editable, which queries and which reports are available, whether they can create new queries and reports). ## Deliverables **What we need in detail** We need two levels of access, one for administrators who can see all data fields, create custom views and queries, edit existing views and queries, add or alter data, and add users. The second level would be client level, and while they can perform searches or select different views, they cannot edit any information, and are restricted to whatever sections of data the administrator has granted them permission to see. Furthermore, we need to able to group clients into categories, each category having its set of permissions. We should be able to create our own categories. We need two data tables, one with approximately one million rows of data, and the other about six thousand rows. Both tables have about 12-15 columns in them, and we do not need any relational tables. We will provide this data to you, and it consists of names, addresses, 12 digit Tax ID Numbers, phone numbers, and some financial information in the form of plain numbers, percentage values or alphanumeric information. We need to have a way to easily upload data from excel spreadsheets and to alter data in either of the two tables, and this should be accomplished through a simple Graphical User Interface. There is no graphic design necessary here, just simple layout and standard input fields We need to be able to create custom queries with the GUI, be able to choose which criteria are used, and even select between the different Boolean operators. These queries would also need to have their permission sets, so we can control which clients see which queries. We need a similar system for creating or modifying reports (a report being a static list or summary generated upon request based upon information from the database). Again, each report type would need its own permission set, for the control reasons described above. The reports should also have the capability to generate simple, printable graphs and perform basic calculations like averages, arithmetic means, and such. Finally, depending on how close to budget the project is, we would like to be able to offer clients a simple paste in script for their website that allows them to display information directly from our database, report result, or search interface on their website. ------------------------------------------------------------ Rent A Coder requirements notice: As originally posted, this bid request does not have complete details. Should a dispute arise and this project go into arbitration "as is", the contract's vagueness might cause it to be interpreted against you, even though you were acting in good-faith. So for your protection, if you are interested in this project, please work-out and document the requirements onsite. 1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work [login to view URL] and fully-functional simple graphical user interface. Complete documentation on use of software (for employee training purposes) and development notes (description of how the software was created to assist future modifications of software). 2) Deliverables must be in ready-to-run condition, as follows (depending on the nature of the deliverables): a) For web sites or other server-side deliverables intended to only ever exist in one place in the Buyer's environment--Deliverables must be installed by the Seller in ready-to-run condition in the Buyer's environment. b) Once everything has been installed and is "ready-to-run", we would like go through a quick guided (by developer) test run of the software to ensure that that it is actually complete and fully functional as requested. If any revisions need to be made, we will be willing to pay on a revision-by-revision basis. 3) All deliverables will be considered "work made for hire" under U.S. Copyright law. Buyer will receive exclusive and complete copyrights to all work purchased. (No GPL, GNU, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site per the coder's Seller Legal Agreement). * * *This broadcast message was sent to all bidders on Wednesday Feb 22, 2006 3:46:53 PM: I have updated the project proposal with addtional details and information. ## Platform We already have a shared and hosted MS SQL database with an online provider, and we have our data in excel spreadsheet and/or MS Access format. we want to access this application, as described above, through a web based GUI as described above, all versions of windows explorer. the database enviroment is a shared license, hosted MS SQL database. login information will be provided to developer so that they can evaluate and work with the database.