Subject : Database Concept and design

Examine the Patient Medication Form for the Wellmeadows Hospital case study shown in figure. Wellmeadows Hospital Patient Medication Form a) Identify all the dependencies in order for the table to be in the first normal form (1NF). Draw the dependency diagram. [6 marks] b) Based on your 1NF in (a), draw the dependency diagram for the second normal form (2NF). [4 marks] c) Based on your 2NF in (b), draw the dependency diagram for the third normal form (3NF). [4 marks] d) Write the Relational Schema that conform to Third Normal Form (3NF). [2 marks] e) Draw a Crow's Foot ERD based on the final tables from your 3NF in (d). [4 marks]