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. please EER DIGRAM NOT A UML Class Digram
 [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!