WEEK: Q1. Entity Relationship Diagram (ERD) design According to the description below, design the ERD. Please also show cardinality constraints on your ERDs [25 Marks]. Nurses, doctors and patients are Persons who has person id, name and date-of-birth. Nurses and Doctors have speciality . In addition, Nurses and Doctors belong to one department. Departments have department id, building and dept name." Nurses may take place in patient visits. Doctors are examining many patients but a patient can see only one doctor Patients may get medical or operational treatments For those patients who need to be treated with medication medication details are included such as medication name, interval.

Question

WEEK: Q1. Entity Relationship Diagram (ERD) design According to the description below, design the ERD. Please also show cardinality constraints on your ERDs [25 Marks]. Nurses, doctors and patients are Persons who has person id, name and date-of-birth. Nurses and Doctors have speciality . In addition, Nurses and Doctors belong to one department. Departments have department id, building and dept name." Nurses may take place in patient visits. Doctors are examining many patients but a patient can see only one doctor Patients may get medical or operational treatments For those patients who need to be treated with medication medication details are included such as medication name, interval.

Answer 1

Based on the description provided, the Entity Relationship Diagram (ERD) would have the following entities:1. Persons (Nurses, Doctors, Patients) * Attributes: person\_id, name, date-of-birth2. Specialties * Attributes: specialty\_id, specialty\_name3. Departments * Attributes: department\_id, building, dept\_name4. Visits * Attributes: visit\_id, person\_id, visit\_date5. Treatments * Attributes: treatment\_id, patient\_id, treatment\_type, medication\_name, interval6. Examines * Attributes: examine\_id, doctor\_id, patient\_id, examine\_date7. Medications * Attributes: medication\_id, medication\_name, intervalThe cardinality constraints for the ERD would be:1. One-to-One (1:1) relationship between Persons and Specialties for Nurses and Doctors.2. One-to-One (1:1) relationship between Persons and Departments for Nurses and Doctors.3. One-to-Many (1:N) relationship between Visits and Persons (Nurses and Doctors).4. One-to-Many (1:N) relationship between Examines and Doctors.5. One-to-Many (1:N) relationship between Examines and Patients.6. One-to-Many (1:N) relationship between Treatments and Patients.7. One-to-Many (1:N) relationship between Medications and Treatments.Note: The above ERD is a simplified representation based on the provided description and may need further refinement based on additional requirements or constraints.

Soru

Çözüm

Cevap