Question: [ 2 5 points ] A hospital database is designed to keep track of doctors ( identified by doctor _ id , with specialization and
points
A hospital database is designed to keep track of doctors identified by doctorid with specialization and email as attributes patients identified by patientid with name and dateofbirth as attributes and treatments administered by doctors to patients with treatmentdate and treatmenttype 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 treatmentdate 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 projectid with projectname and startyear as attributes and each project must be uniquely identified by its projectname when the lead doctor is known.
Draw an EER diagram that captures this information.
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
