Create the ER diagram in crows foot diagram and fix the primary keys and label them as well the connecting between the people and visit fix it and add it to the doctor. Make sure that all the entities are in their correct place with the subtypes and super type.

Fix the below crow foot er diagram by fixing the M to N ones in the employees, location, and all the other tables that need to be fixed

 

  

Transcribed Image Text:

HomePhone Zip State City Gender PersonID Patient People Patient WorkPhone Lastname PersonID CellPhone Firstname PersonID Doctor GardDate attends Specialty Medical School (Diagnosis_VisitID DiagnosisID VisitID Visit gets Diagnosis_Visit has Diagnosis PatientID (FK) visitDate diagnosisID (FK) VisitID (FK) diagnosis HomePhone Zip State City Gender PersonID Patient People Patient WorkPhone Lastname PersonID CellPhone Firstname PersonID Doctor GardDate attends Specialty Medical School (Diagnosis_VisitID DiagnosisID VisitID Visit gets Diagnosis_Visit has Diagnosis PatientID (FK) visitDate diagnosisID (FK) VisitID (FK) diagnosis