Entity Relational (ER) diagram, or Extended Entity Relational (EER) diagram based on the information at the bottom. I am not sure how to create the digram. 

 

In a busy medical facility, individuals are treated and identified by a unique code, and their names and home addresses are kept on record. There are two types of individuals, one who stays in the facility and is assigned a room number (Inpatient), and the other who visits the facility and is given a date for their next appointment (Outpatient). Additionally, the medical facility keeps medical records for all patients. Each record is associated with a unique number, the date it was created, and a diagnosis. 

 

The medical facility also maintains a detailed catalog of health professionals, each with their unique identifiers and specialty fields. These professionals are involved in the administration of various treatments, each of which is given a unique code, a name, and a detailed description. A treatment can be administered by a health professional to an individual at a given date and time.

Answer rating: 100% (QA)

Creating an EntityRelationship ER diagram or an Extended EntityRelationship EER diagram can help you visualize the data model for the described scenar... View the full answer