Closed

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

[url removed, login to view]

***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 [url removed, login to view] 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.

Skills: Article Rewriting, Engineering, MySQL, PHP, Research Writing, Software Architecture, Software Testing, SQL, Translation, User Interface / IA

See more: w.s. development, working online graphic design, who project proposal format, who made graphic design, which platform is good for web development, which application do i need to design a website, what software should i use for web design, what software do i need for graphic design, what should i pay for graphic design, what is a contract to hire position, what do you need to do to design a website, what do website developer offer, what do i need to hire an employee, what does web developer do, what does the graphic design, what does rent a coder do, what does php developer's do, what does php developer do, what does graphic design do, what does a web application developer do, what are graphs used for, what are databases and what are they used for, what a levels do you need to do graphic design, what a levels do you need for graphic design, website for numbers design seller

About the Employer:
( 0 reviews ) Toronto, Canada

Project ID: #3290786

16 freelancers are bidding on average $1761 for this job

hits

See private message.

$1275 USD in 30 days
(893 Reviews)
8.8
miguelkhouri

See private message.

$1275 USD in 30 days
(77 Reviews)
7.4
DebasisB

See private message.

$1275 USD in 30 days
(143 Reviews)
7.0
AcuityInfotech

See private message.

$2550 USD in 30 days
(29 Reviews)
6.8
TSSIPL

See private message.

$1275 USD in 30 days
(18 Reviews)
6.4
dkumarlx

See private message.

$2550 USD in 30 days
(2 Reviews)
5.2
eltonlabajo

See private message.

$425 USD in 30 days
(40 Reviews)
4.9
thinkandcare

See private message.

$425 USD in 30 days
(48 Reviews)
4.8
gabysc

See private message.

$1572.5 USD in 30 days
(3 Reviews)
3.4
zeeboo

See private message.

$425 USD in 30 days
(5 Reviews)
1.3
davebernard

See private message.

$7225 USD in 30 days
(0 Reviews)
0.0
it2006

See private message.

$2550 USD in 30 days
(0 Reviews)
0.0
dhtechus

See private message.

$1700 USD in 30 days
(1 Review)
0.0
robertobidinski

See private message.

$2550 USD in 30 days
(0 Reviews)
0.0
vw1778478vw

See private message.

$680 USD in 30 days
(1 Review)
0.0
alibhatti

See private message.

$425.85 USD in 30 days
(0 Reviews)
0.0