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