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 PatientID PatientName, PatientTel
Doctor DoctorID DoctorName, DoctorSpecialty
Examination DoctorID PatientID ExaminationRoomID Date, Time, MedicalNote
ExaminationRoom ExaminationRoomID ERoomType, BuildingID 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
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
