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

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 atient idPatient namePatient addressTr 237651Williams Albury 237651 Williams Albury 49821 Baker 54987 Smith 34159 Jacobs riage categoryFirst seen byPresenting problem

OR

 

OR