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 dependencydiagram. Make sure that you label the transitive and/or partialdependencies.
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 37651
PayPal Gateway not configured
PayPal Gateway not configured