List the relationship verb phrase for each 'HAS-A' relationship that appears in the diagram.
2. List the relationship verb phrase for each binary relationship that appears in the diagram.
3. List the relationship verb phrase for each recursive relationship that appears in the diagram.
4. List the name of each supertype entity that appears in the diagram.
5.List the name of each subtype entity that appears in the diagram.
6. Provide an example of an entity instance of PERSON.
7.List the relationship verb phrase for every 1:1 relationship that appears in the diagram.
9. List the relationship verb phrase for every M:N relationship that appears in the diagram.

10. List the name of each strong entity that appears in the diagram.
11. List the name of each weak entity that appears in the diagram.
12. Must a STAFF:managee be managed by a manager?  Explain how you determined your answer from the E-R diagram provided.

13.Can there be an instance of DOCTOR that is not an instance of STAFF?  Explain your answer.

14. Can a DOCTOR treat more than one PATIENT?  Explain how you determined your answer from the E-R diagram provided.
15. Must every instance of PERSON belong to a subtype?  Fully explain how you determined your answer from the E-R diagram provided.
16.( Could an instance of PERSON be both a STAFF and a PATIENT?  Fully explain how you determined your answer from the E-R diagram provided.

17. Must every instance of STAFF belong to a subtype?  Fully explain how you determined your answer from the E-R diagram provided.
18. Could an instance of STAFF be both a SUPPORT_STAFF and a DOCTOR?  Fully explain how you determined your answer from the E-R diagram provided.
19. If a discriminator were to be added to PERSON, fully explain what that would entail and why?
20.If a discriminator were to be added to STAFF, fully explain what that would entail and why?
21. Fully state the business rules for the assigned to/assigned relationship without using technical terms.

 

Transcribed Image Text:

DEPARTMENT wage dept# name managee manage OH manager assigned to/assigned job Title SUPPORT STAFF Wellness Hospital STAFF d NURSE certification PERSON personID firstName lastName dob PATIENT DOCTOR deaNumber mentor treat/treated by mentee mentors DEPARTMENT wage dept# name managee manage OH manager assigned to/assigned job Title SUPPORT STAFF Wellness Hospital STAFF d NURSE certification PERSON personID firstName lastName dob PATIENT DOCTOR deaNumber mentor treat/treated by mentee mentors

Answer rating: 100% (QA)

Based on the provided EntityRelationship ER diagram for the Wellness Hospital I will answer the relevant questions 1 There is no question number 1 provided 2 List the relationship verb phrase for each ... View the full answer