In Progress

Very Simple Access Database. Work will not be used commercially.

Hi Everybody,

I am in need of a simple Access database. Should be relatively easy, but I am in need of it by 12:00 pm Pacific Time March 26, 2008. It’s simply a test database which we are integrating with another program to see how well something like this would work. There are some general requirements though. Take a look, and generally, I will award the bid within 8-12 hours of this post, and hopefully you can have it done by the deadline. Here are the details:

The file naming convention is Lastname. Firstname.MDB. Please pay special attention to the capitalization.

The relationship diagram should include the following 4 items of identifying information:

1. Last Name =

2. First Name =

3. SID =

4. Email =

Please minimize data redundancy in the design.

NOTE: There should only be one relationship between each pair of tables. There is no need to populate the database with data.

Please read carefully this scenario. It is vital in seeing how well our program will work. Please note that your work will not be used in any final version or commercially released item. This is simply a test for something that we have created, we just don’t have the time to create the database ourselves.

Design a database for a small medical practice that has a small amount of Physicians.

1. Any patient may see any physician, and over time one patient will see many physicians.

2. A patient may complain about multiple ailments, all of which can be treated in a single appointment.

3. The patient sees only one physician per appointment.

4. The medical practice prefers to use standard phraseology in describing the aliments of patients; thus the database should keep all of the ailment information (description, treatment, charge, date treated, treating physician) in a separate ailment table.

Please keep in mind again then that one appointment can deal with multiple ailments, and the same ailment can be treated in different appointments.

The database should include separate tables for patients and physicians, with appropriate fields in each table.

Please demonstrate a large use of the application of one-to-many and many-to-many relationships, referential integrity, and usage of the relationships window.

Completion will also then qualify you for future jobs. Payment terms will be 50% and 50% upon presentation of ability.

Skills: Data Entry, Data Processing, Visual Basic, Website Design, Windows Desktop

See more: work pacific, vital design, visual design jobs, test scenario, simple file database, scenario presentation design, scenario presentation, presentation design jobs, physician jobs, per work, pacific jobs, naming jobs, jobs pay well, jobs pacific, easy jobs pay well, design jobs description, design access database, database design jobs, database used, simple patients access database, standard phraseology describing aliments, appointment ailments, treating multiple ailments appointment, patients access database, access database work

About the Employer:
( 1 review ) Yorba Linda, United States

Project ID: #241116

Awarded to:

expertMan

ready for your work

$50 USD in 1 day
(30 Reviews)
6.0

5 freelancers are bidding on average $62 for this job

Chishti

Hi,Please SEe PM thanks

$100 USD in 0 days
(29 Reviews)
5.4
ahmedwaqqas

Plz view PM for sample work ... Thanks!

$75 USD in 1 day
(6 Reviews)
4.1
kingshijin

I will provide the package as the time i have specified

$45 USD in 1 day
(0 Reviews)
0.0
samuech

Hi, I have extensive experience with MS Access and Database Design (in General). Please check PM. Thanks

$40 USD in 1 day
(0 Reviews)
0.0