Entity

ERDPlus.com Assignment **

Create an entity based on the following scenarios.

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

(b) Create an entity based on the following requirement:

For each doctor, we will keep track of a DoctorID (unique), DoctorName, DoctorYearOfMDGraduation (year of graduating from medical school), and one or more specializations.

(c) Create an entity based on the following requirement:

For each doctor, we will keep track of a DoctorID (unique), DoctorName, DoctorYearOfMDGraduation (year of graduating from medical school), and DoctorYearsPracticing (how many years the doctor has been practicing medicine). Note that DoctorYearsPracticing attribute can be calculated from the DoctorYearOfMDGraduation.

Create the ER diagrams for a scenario based on these common requirements for (d)-(f):

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

Do not forget to specify minimum and maximum cardinalities when drawing relationships.

(d) Additional requirement

Each doctor works at exactly one outpatient location, and each outpatient location can have between none (rehab and minor health issues only) and many doctors working at it.

(e) Additional requirement

Each doctor works at either one outpatient location or at none (strictly working in the main hospital), and each outpatient location has exactly one doctors working at it.

(f) Additional requirements

Each doctor works at between one and many outpatient locations, and each outpatient location must have at least one but can have many doctors working at it.

Each doctor manages between zero and one outpatient locations, and each outpatient location has exactly one doctor managing it.

Download pictures from ERDPlus.com, insert them into a Word file, and submit.