Keep Track Patients Clinician Etc Private Hospital Uses Table Structure Shown Table 1 Pati Q37068384

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.

b. Modify the dependency diagrams that meet 3NFrequirements. Rename attributes to meet the naming conventions, andcreate new entities and attributes as necessary.

c. Draw the Crow’s Foot ERD.

Patient Report addressTriage c rst seen atient cian nam 160 104 310 10 19

OR

 

OR