Patients are seen by physicians either in hospitals or clinics. Each patient visit to a clinic or hospital generates a physician encounter. Each patient visit may generate a referral to a laboratory for further testing.

1. design a data model in the form of an entity-relationship diagram.
2. With the following entities in the solution: Patient, PatientVisit, and LabOrder.