Draw an EER diagram 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.

To receive full credit for this assignment you must do the following before the due date:

• You must create your EER diagram using a computer drawing package that supports ER diagramming. Installation instructions for ER diagramming software are posted on Blackboard under Course Documents => E-R Diagramming Software Installation Instructions.
• Use "Crow's Foot" ER diagram notation for all relationships except for the relationships between supertypes and subtypes.