Laboratory exercise involves a complete development of a relational database. You are to do the following:
1. Use Visio to create the appropriate diagrams.
2. Create a script named mdbXXX.sql (where XXX are your initials) that
- Create the tables in 3NF needed to implement your DB schema.
- Your tables must include primary and foreign keyconstraints.
- Populate the database.
- Create the report that includes all three patients.
- Each student will be required to add an individual query. See your instructor for the specifications of your query.
Patient Doctor Room Admitted Required Medication
-------------------------------------------------------------------- -----------------------------------
1001 Fred Payne 101 MARCH 31, 2004 2 Prozac 3 grams annually
6 Aspirin 1 gram daily
9 Valium 2 grams weekly