In Class Practice Assignment: ER Diagramming - Medical Clinic

Examine the following scenarios in a clinical setting

Patients are treated in wards in the clinic, the patients are seen by doctors, doctors have assistants, patients may also be seen by the doctor’s assistants, assistants are assigned to wards. Doctors write prescriptions for the patients. 

Create an Entity-Attribute-Relationship Diagram (ERD) to represent the conceptual model of a database that could connect the transactions in these scenarios. Create any entities that would be needed, create any associated relationships need to illustrate the scenario. For each entity  you illustrate, add 3 to 5 attributes,   Identify the primary keys and the foreign keys that you would use. Remember, include a couple of descriptive attributes for any Entity or Relationship items in the diagram that you think may help identify them. Remember for this assignment, we are only concerned with the (EAR) segment of modeling. Identify the Entities, their Attributes, the Relationships associated with the each entity. Connect these items using a connection line. We also discussed carnality; try to identify the carnality in the relationships. This project may be completed in Visio, Word, or another modeling software application.

Submit a PDF file containing the ER Diagram