IS 314 Database design and Management Homework 1

Homework 1

INSTRUCTIONS:

In order to complete this homework, draw the Diagram for the following description using ERDPlus or by hand and upload the images through Moodle.

  • Create an entity based on the following requirement:
    • For each doctor, we will keep track of a DoctorID (unique), DoctorLicense (unique, composed of LicenseNo and State), DoctorName, and DoctorYearOfMDGraduation (year of graduating from medical school).
  • 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 (year of graduating from medical school).
    • For each outpatient location it keeps track of the OLID (unique) and OLName

Additional requirement

  • Each doctor works at exactly one outpatient location, and each outpatient location has exactly one doctor working at it.

Do you want answer for this assignment