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 blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Programming Questions!