Subject : Database Concept and design

The manager of a clinic would like to have an information system that assists him to keep track the patient records. However, the manager is not an information system expert. The following table is used to store the information. Tahla1. Samnla Mata nf Pationt Rarnrds a) Identify the partial dependencies and transitive dependencies for the table. Draw the Dependency Diagram that is in First Normal Form (1NF). [6 marks] b) Convert the Patient Records Table into 3rd Normal Form (3NF). [6 marks] c) Write the relational schema and show the result of each step in the normalization process. [4 marks] d) Draw a Crow's Foot ERD based on the final tables from your 3NF in (c). [4 marks]