Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

[ 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.
image text in transcribed

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

More Books

Students also viewed these Databases questions