This project has two parts:
This project will be the foundation for Projects #2 and #3, so you must complete this project correctly or you will not be able to complete the subsequent projects.
Scenario
You are running a small, walk-in clinic in a large corporation. Generally, you only see employees of the company and only for small matters (cuts, bruises, and other minor injuries, or colds, flu, etc., that would necessitate sending the employee home or treating them and returning them to work). Because of its limited nature, your clinic only handles a few problems. Your clinic has 5 attending physicians. Each visitor to the clinic must be registered as a patient (if not already registered) and is then seen by one of the physicians. The patient is treated or given a diagnosis. Some treatments will involve medications, however your clinic only handles a few medications. Some treatments will require no medication and others will require one or two. There is a cost associated with each medication and each visit to a physician. The cost of the consultation depends upon the diagnosis.
The system you are creating must handle all of the patient visits. Ultimately, we will need to be able to create a patient bill for the month, showing all of their visits in detail and a total amount owed. You will also need to create a report of physician activity and a report of all medications administered. These reports will be created in a future project.
Part One - Database Design
Since this database will be used for this and future projects, it is always best to have it properly designed before actually creating the database and adding data to it.
Using steps outlined in previous class sessions, design your database so that it is in Third Normal Form. The design must be turned in with this project, so take great care with it. A poor design will result in many problems later on and will end up costing you much additional time and effort over a good initial design.
You should do your design using an ERD (entity relationship diagram). You can view a sample PDF ERD if you don't know what one is or look up examples on the Internet.
You can create an ERD in MS Word. Alternatively, you can use the relationships diagram in Access and print from there. If you want to do that, use Database Tools/Relationship Diagram and then move things around (drag and drop) until they look good. Then select the report and output as a PDF file. This way, the ERD will match exactly what you have in your database, since it will have been generated by it. You can view a sample of this output here.
For this project, half your points will come from the design and half from the created tables.
Part Two - MS Access Database
Implement your design by creating the tables in Microsoft Access in a database called "XYZn3500", where you substitute your initials for XYZ and the month of your birth for "n". For example, if your name is Bozo T. Clown and you were born in August, the name of your database would be BTC83500. You must adhere to this naming convention for your database to avoid problems when turning it in for grading.
You should enter sample data into your tables. For treatment and medication information, you can use the information I have provided here. Make up at least 5 physicians and 25 patients. Also, input at least 10 office visits.
Deliverables
For this project, you will need to turn in a copy of your ERD and a copy of your database file. These files can be attached to an email sent to me in WebCT. They must be submitted before the deadline, 11:59 a.m. on Friday, February 26th.