Be sure to follow the guidelines for drawing an ER diagram.

Entity 1: Patients Relationship: 1:M (Patients to Appointments)

Entity 2: Appointments Relationship: 1:1 (Appointments to Patient)

Entity 3: Doctors Relationship: 1:M (Doctors to Appointments)

Entity 4: Insurance Companies Relationship: 1:M (Insurance Companies to Patients)

Entity 5: Payments Relationship: 1:1 (Payments to Appointments)

Entity 6: Prescriptions Relationship: 1:M (Prescriptions to Patients)

Entity 7: Diagnoses Relationship: 1:M (Diagnoses to Appointments)

Entity 8: Tests Relationship: 1:M (Tests to Appointments)

Answer rating: 100% (QA)

Medical Clinic ER Diagram Heres the ER diagram for a medical clinic following the guidelines Entitie... View the full answer