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
Get step-by-step solutions from verified subject matter experts
