Question: [ 2 5 points ] A hospital database is designed to keep track of doctors ( identified by doctor _ id , with specialization and

[25 points]
A hospital database is designed to keep track of doctors (identified by doctor_id, with specialization and email as attributes), patients (identified by patient_id, with name and date_of_birth as attributes), and treatments administered by doctors to patients (with treatment_date and treatment_type as attributes). Doctors can be assigned to multiple patients; each patient has a primary care doctor (who is one of the doctors); and each treatment must be uniquely identified by its treatment_date when the doctor and patient are known. We are not interested in the treatments given by a doctor once they leave the hospital. Additionally, doctors collaborate on research projects (identified by project_id, with project_name and start_year as attributes), and each project must be uniquely identified by its project_name when the lead doctor is known.
Draw an EER diagram that captures this information.
 [25 points] A hospital database is designed to keep track of

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!