System Analyst and Design
Create a data model in the form of an Entity-Relationship Diagram to express the following data requirements of a certain information system.
A medical clinic wants to record data about its doctors and patients. They also need to know about the appointments scheduled. Following each appointment, a doctor will update the patient's medical record with the diagnosis and any prescriptions. Other examinations by specialists may also be requested.
Make logical assumptions about the maximum and minimum occurrences of entities in order to complete all the relationships.