ERD

Get your Assignment in a Minimum of 3 hours

Our academic experts are ready and waiting to assist with any writing project you may have. From simple essay plans, through to full dissertations, you can guarantee we have a service perfectly matched to your needs.

Free Inquiry Order A Paper Now Cost Estimate

Assume the following scenario : A health care organization keeps track of its doctors and outpatient locations. For each doctor it  keeps track of the Doctor ID (unique), Doctor Name, and Doctor Year Of MD Graduation (year of  graduating from medical school). For each outpatient location it keeps track of the OLID  (unique) and OL Name.

For each of a and b 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. and  b. Your ERD should shows the degree and cardinalities of each relationship.

a) (4 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.

b) (4 pts) Each doctor must work at exactly one outpatient location, and each outpatient location can have  between none and many doctors working at it.

"Is this question part of your assignment? We Can Help!"

"Our Prices Start at $11.99. As Our First Client, Use Coupon Code GET15 to claim 15% Discount This Month!!"

Get Started