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.