+1-617-874-1011 (US)
+61-7-5641-0117 (AU)
+44-117-230-1145 (UK)
Live Chat

IS 314 Database design and Management Homework 1


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.
Want solution for this assignment
Improve Your Grades with Custom Writing Help
Homework Help
Writing Help
Editing Services
Plagiarism check
Proofreading services
Research Project help
Custom writing services
E learning blogs

Disclaimer : The study tools and academic assistance/guidance through online tutoring sessions provided by AssignmentHelp.Net is to help and enable students to compete academically. The website does not provide ghostwriting services and has ZERO TOLERANCE towards misuse of the services. In case any user is found misusing our services, the user's account will be immediately terminated.