To keep track of patients and clinician, etc., a privatehospital uses the table structure shown in Table 1 PatientReport
a. Given that information, draw the dependency diagram. Makesure that you label the transitive and/or partial dependencies. (5Marks) b. Modify the dependency diagrams that meet 3NFrequirements. Rename attributes to meet the naming conventions, andcreate new entities and attributes as necessary. (5 Marks) c. Drawthe Crow’s Foot ERD. (5 Marks)
Expert Answer
An answer will be send to you shortly. . . . .