Question: Create the ER diagrams for a scenario based on these requirements: A health care organization keeps track of its doctors and outpatient locations. For each
Create the ER diagrams for a scenario based on these
requirements:
A health care organization keeps track of its doctors and outpatient locations.
For each doctor it keeps track of the DoctorID unique DoctorName, and
DoctorYearOfMDGraduation.
For each outpatient location it keeps track of the OLID unique and OLName, and the
following additional requirement:
a Each doctor works at exactly one outpatient location, and each outpatient location
can have between none rehab and minor health issues only and many doctors
working at it
b Each doctor works at either one outpatient location or at none strictly working in
the main hospital and each outpatient location must have at least one but can
have many doctors working at it
c Each doctor works at exactly one outpatient location, and each outpatient location
must have at least one but can have many doctors working at it
d Each doctor works at either one outpatient location or at none strictly working in
the main hospital and each outpatient location can have between none rehab
and minor health issues only and many doctors working at it
e Each doctor manages between zero and one outpatient locations, and each
outpatient location has exactly one doctor managing it
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
