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