Using Crow's feet notation, develop a data model (E-R diagram) for the following scenario. You can draw it in a paper and submit it-
A doctor's office has several doctors. They want to store information about their patients and employees (including doctors). A patient can have a variable number of emergency contacts. Also they want to keep track of the person who recommended the patient. it could be another patient or an associate. Also whenever a patient comes to see a doctor they store information about the appointment.
The E-R diagram should show the important attributes for each entity. You must show the relationships among the entities accurately.