Question: Draw an EER diagram using Microsoft Visio that models the business operation of hospital employees. The following business rules apply: An EMPLOYEE may be either

Draw an EER diagram using Microsoft Visio that models the business operation of hospital employees. The following business rules apply:

  • An EMPLOYEE may be either a DOCTOR, NURSE, or RECEPTIONIST.
  • A DOCTOR must be either a SURGEON or ANETHESIOLOGIST.
  • A NURSE can be certified as an ER NURSE and/or a SURGICAL ASSISTANT.
  • A RECEPTIONIST is assigned to many DOCTORS.
  • A DOCTOR must have only one RECEPTIONIST.

Show the following items on your diagram:

  • Supertype completeness constraints
  • Subtype, disjointness constraints
  • Subtype discriminator attributes in each supertype
  • Minimum and maximum cardinalities on all relationships
  • List the attributes for each entity type in your model.

You must create your EER diagram using Microsoft Visio. Use "Crow's Foot" ER diagram notation for all relationships except for the relationships between supertypes and subtypes.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!