Assignment Hippo Loader





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
AssignmentHippo Features
  • On Time Delivery

    Our motto is deliver assignment on Time. Our Expert writers deliver quality assignments to the students.

  • Plagiarism Free Work

    Get reliable and unique assignments by using our 100% plagiarism-free services.

  • 24 X 7 Live Help

    The experienced team of AssignmentHippo has got your back 24*7. Get connected with our Live Chat support executives to receive instant solutions for your assignment problems.

  • Services For All Subjects

    We can build quality assignments in the subjects you're passionate about. Be it Programming, Engineering, Accounting, Finance and Literature or Law and Marketing we have an expert writer for all.

  • Best Price Guarantee

    Get premium service at a pocket-friendly rate. At AssignmentHippo, we understand the tight budget of students and thus offer our services at highly affordable prices.

Tap to Chat
Get instant assignment help
Tap to Chat
Get instant assignment help