Question

Assume the following scenario : 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 (year of graduating from medical school). For each outpatient location it keeps track of the OLID (unique) and OLName. For each of a, b and c an extra information is added to the scenario. Use the scenario above and the respective extra information to draw the corresponding ER diagram for each of a. b. and c. Don't forget the degree and cardinalities of each relationship. a) (3 pts) Each doctor must work at exactly one outpatient location, and each outpatient location can have between none and many doctors working at it. b) (3 pts) Each doctor works at either exactly one outpatient location or at none (strictly working in the main hospital), and each outpatient location must have exactly one doctor working at it. c) (3 pts) Each doctor works at between none and many outpatient locations, and each outpatient location must have at least one but can have many doctors working at it.

          Assume the following scenario :
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 (year of
graduating from medical school). For each outpatient location it keeps track of the OLID
(unique) and OLName.
For each of a, b and c an extra information is added to the scenario. Use the scenario above
and the respective extra information to draw the corresponding ER diagram for each of a. b.
and c.
Don't forget the degree and cardinalities of each relationship.
a) (3 pts)
Each doctor must work at exactly one outpatient location, and each outpatient location can
have between none and many doctors working at it.
b) (3 pts)
Each doctor works at either exactly one outpatient location or at none (strictly working in the
main hospital), and each outpatient location must have exactly one doctor working at it.
c) (3 pts)
Each doctor works at between none and many outpatient locations, and each outpatient location must
have at least one but can have many doctors working at it.

Assume the following scenario :
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 (year of
graduating from medical school). For each outpatient location it keeps track of the OLID
(unique) and OLName.
For each of a, b and c an extra information is added to the scenario. Use the scenario above
and the respective extra information to draw the corresponding ER diagram for each of a. b.
and c.
Don't forget the degree and cardinalities of each relationship.
a) (3 pts)
Each doctor must work at exactly one outpatient location, and each outpatient location can
have between none and many doctors working at it.
b) (3 pts)
Each doctor works at either exactly one outpatient location or at none (strictly working in the
main hospital), and each outpatient location must have exactly one doctor working at it.
c) (3 pts)
Each doctor works at between none and many outpatient locations, and each outpatient location must
have at least one but can have many doctors working at it.

Added by Kevin S.

Question

Please give Ace some feedback