Recent Meeting Among Board Directors Qatar Foundation Qf Concluded Decision Collecting Sto Q43881337
Part II:
https://www.chegg.com/homework-help/questions-and-answers/-q43881322
A recent meeting among the board of directors of Qatar Foundation (QF) has been concluded with the decision of collecting and storing information pertaining to all organizations in QF and their employees. The information will be used primarily for their emergency notification system among other things. An expert (you!) has been hired to design their database given the following description of entities and relations: Every organization has a unique name (e.g. Carnegie Mellon University in Qatar, Student Center, etc., address within QF, and contact numbers. An organization can be classified as University, Company, Vendor, or Activities Cen- ter. Texas A&M University, Al-Jazeera for Children, Bateel Cafe, and Awsaj Recreational Center are examples of each category, respectively. QF records the majors, product line, cuisine, and types of activities for the above categories, respectively. • Every employee has a name, contact number, and employee ID. An employee may work for several organizations, but at least for one. For example, employee X may work for the Recreation Center in the morning while for the Community Center in the afternoon. Accordingly, for every employee, we must record the start and end times at each organization. An employee is either a long-term or a short-term hire and is either local or expatriate. Note that for local hires, QF records the end date of their contracts. • An employee may be appointed as a manager. A manager manages one or more organiza- tion(s). For example, the Recreation Center and Community Center may be managed by the same manager. • Each organization should be managed by at most one manager. 2pts (a) Consider the works for relationship between the entities organization and employee. Correct the errors (if any) in the following E.R. Diagram. You may either use the thin/thick ‘arrow’ notation of the book, or the M:N notation. 1 N Organization Works for Employee 15pts (b) Draw the E.R. diagram for QF’s database as described above. Make sure to indicate primary and partial keys, cardinality constraints, weak entities, and participation constraints where applicable. Please state any assumptions that you make. 3pts (c) State whether the organization ISA hierarchy has (a) covering and/or (b) overlapping constraints. Explain briefly. 5pt State whether the employee ISA hierarchy has (a) covering and/or (b) overlapping con- straints. Explain briefly. 15pts e) Write SQL statements to create tables corresponding to your E.R. diagram. Make sure to indicate primary keys and foreign keys (if any). Do not specify on delete clauses or check constraints. Show transcribed image text A recent meeting among the board of directors of Qatar Foundation (QF) has been concluded with the decision of collecting and storing information pertaining to all organizations in QF and their employees. The information will be used primarily for their emergency notification system among other things. An expert (you!) has been hired to design their database given the following description of entities and relations: Every organization has a unique name (e.g. Carnegie Mellon University in Qatar, Student Center, etc., address within QF, and contact numbers. An organization can be classified as University, Company, Vendor, or Activities Cen- ter. Texas A&M University, Al-Jazeera for Children, Bateel Cafe, and Awsaj Recreational Center are examples of each category, respectively. QF records the majors, product line, cuisine, and types of activities for the above categories, respectively. • Every employee has a name, contact number, and employee ID. An employee may work for several organizations, but at least for one. For example, employee X may work for the Recreation Center in the morning while for the Community Center in the afternoon. Accordingly, for every employee, we must record the start and end times at each organization. An employee is either a long-term or a short-term hire and is either local or expatriate. Note that for local hires, QF records the end date of their contracts. • An employee may be appointed as a manager. A manager manages one or more organiza- tion(s). For example, the Recreation Center and Community Center may be managed by the same manager. • Each organization should be managed by at most one manager.
2pts (a) Consider the works for relationship between the entities organization and employee. Correct the errors (if any) in the following E.R. Diagram. You may either use the thin/thick ‘arrow’ notation of the book, or the M:N notation. 1 N Organization Works for Employee 15pts (b) Draw the E.R. diagram for QF’s database as described above. Make sure to indicate primary and partial keys, cardinality constraints, weak entities, and participation constraints where applicable. Please state any assumptions that you make. 3pts (c) State whether the organization ISA hierarchy has (a) covering and/or (b) overlapping constraints. Explain briefly. 5pt State whether the employee ISA hierarchy has (a) covering and/or (b) overlapping con- straints. Explain briefly. 15pts e) Write SQL statements to create tables corresponding to your E.R. diagram. Make sure to indicate primary keys and foreign keys (if any). Do not specify on delete clauses or check constraints.
Expert Answer
Answer to A recent meeting among the board of directors of Qatar Foundation (QF) has been concluded with the decision of collectin…
OR