Question: Designing a Database ( Entity Relationship Modeling You have been asked to design a database of an information system to support a medical clinic. The

Designing a Database (Entity Relationship Modeling
You have been asked to design a database of an information system to support a medical clinic. The system needs to keep details of Patients, Doctors, Examinations and Examination Rooms. A Doctor can be responsible for examining a number of patients, or none; each patient can receive zero or more than one examination, and each examination can take place in one or more rooms, but must be in at least one room. Here are the entities and an initial list of attributes for each:
Patient (Patient_ID, Patient_Name, Patient_Tel)
Doctor (Doctor_ID, Doctor_Name, Doctor_Specialty)
Examination (Doctor_ID, Patient_ID, ExaminationRoom_ID, Date, Time, MedicalNote)
ExaminationRoom (ExaminationRoom_ID, E_Room_Type, Building_ID, Floor)
Draw an (initial) Entity Relationship Diagram representing the entities and the relationships above.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!