Question
This assignment must be completed and ready for grading 15 minutes before the end of class on February 17th. Class attendance on both February 12th
This assignment must be completed and ready for grading 15 minutes before the end of class on February 17th. Class attendance on both February 12th and 17th is mandatory to earn credit for this assignment.
Assignment Instructions:
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.
You must create your EER diagram using a computer drawing package that supports ER diagramming. Use "Crow's Foot" ER diagram notation for all relationships except for the relationships between supertypes and subtypes.
Save your completed EER diagram as a PDF file. No credit will be given for drawing files submitted in other formats.
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