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

Question

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

Accepted Answer

The Answer is in the image, click to view ...

Question

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

Step by Step Solution

Step: 1

Get Instant Access to Expert-Tailored Solutions

Step: 2

Step: 3

Ace Your Homework with AI

Recommended Textbook for

Understanding Oracle APEX 5 Application Development