Answered step by step
Verified Expert Solution
Question
1 Approved Answer
[ 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
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started