Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Draw an EER diagram using Draw.io that models the business operation of hospital employees. The following business rules apply: An EMPLOYEE may be either a
Draw an EER diagram using Draw.io 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 Draw.io. 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
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started