Part 1: https://www.chegg.com/homework-help/questions-and-answers/part-ii-https-wwwcheggcom-homework-help-questions-answers-q43881322-q43881337

2 Extending QF's Database [30 Points] Suppose that Qatar Foundation wishes to extend their database to include the phone numbers of visitors and guests. 10pts (a) Qatar Foundation records the name, phone number, and destination of a visitor. A visitor can visit multiple destinations and QF records at least one. For example, a visitor can visit CMUQ followed by the Student Center. Extend the E.R. diagram from Exercise 1 to include the entity visitor and the associated relationship. Clearly indicate primary and partial keys, cardinality constraints, weak entities (if applicable), and participation constraints. 10pts] (b) b) An employee is allowed to exercise at any Activities Center and is also allowed to have two guests associated with him/her. Information stored about a guest is his/her name and age. Guests are assumed to accompany the employee at all times and, hence, emergency messages are sent only to the employee. Once again, extend the E.R. diagram from Exercise 2.A to include the entity guest and all given relationships. Clearly indicate primary and partial keys, cardinality constraints, weak entities (if applicable), and participation constraints. 10pts (c) Write SQL statements to create tables corresponding to your new E.R. diagram. Make sure to indicate primary keys, and foreign keys (if any). Do not specify on delete clauses or check constraints. 2 Extending QF's Database [30 Points] Suppose that Qatar Foundation wishes to extend their database to include the phone numbers of visitors and guests. 10pts (a) Qatar Foundation records the name, phone number, and destination of a visitor. A visitor can visit multiple destinations and QF records at least one. For example, a visitor can visit CMUQ followed by the Student Center. Extend the E.R. diagram from Exercise 1 to include the entity visitor and the associated relationship. Clearly indicate primary and partial keys, cardinality constraints, weak entities (if applicable), and participation constraints. 10pts] (b) b) An employee is allowed to exercise at any Activities Center and is also allowed to have two guests associated with him/her. Information stored about a guest is his/her name and age. Guests are assumed to accompany the employee at all times and, hence, emergency messages are sent only to the employee. Once again, extend the E.R. diagram from Exercise 2.A to include the entity guest and all given relationships. Clearly indicate primary and partial keys, cardinality constraints, weak entities (if applicable), and participation constraints. 10pts (c) Write SQL statements to create tables corresponding to your new E.R. diagram. Make sure to indicate primary keys, and foreign keys (if any). Do not specify on delete clauses or check constraints