please help need urgent . Answer all and get a like. Thanks

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, ete.), address within QF, and contact numbers. - Organization are classified as either a University. Company, Vendor, or Activities Center. Texas ABM University, Al-Jazeera for Children, Bateel Cafe, and Awsaj Recreational Center are examples of each category, respectively. QF records the majors, product lines, cuisines, and types of activities for the above categories, respectively. - One organization has many projects but one project is only assigned to one organization. Each project has an id, a name , a start date and an end date - Every employee has a name, a contact number, and an employee ID. - One Project has many employees and each employce is a member of at least one project. Also, the number of hours worked by an employee on a single project is recorded. - An employee may work for several organizations, but must work for at least one. For example, employee X may work for the Recreation Center in the morning and for the Community Center in the afternoon. Accordingly, for every employee, we must record the start and end times at each organization. - An employee may be appointed as a manager. A manager manages one or more organization(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. - An employee is either a long-term or a short-term hire and is either loeal or expatriate. Note that for local hires, CF records the end date of their contracts. (a) Consider the Manages relationship between the entities Organization and Manager. 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. (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. (c) State whether the organization ISA hierarchy has (i) covering and/or (ii) overlapping constraints. Explain briefly. (d) State whether the employee ISA hierarchy has (i) covering and/or (ii) overlapping constraints. Explain briefly. (c) Write SQL statements to create the tables corresponding to your E.R. diagram. Make sure to indicate the primary keys and the foreign keys (if any). Do not specify on delete clauses or check constraints. 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, ete.), address within QF, and contact numbers. - Organization are classified as either a University. Company, Vendor, or Activities Center. Texas ABM University, Al-Jazeera for Children, Bateel Cafe, and Awsaj Recreational Center are examples of each category, respectively. QF records the majors, product lines, cuisines, and types of activities for the above categories, respectively. - One organization has many projects but one project is only assigned to one organization. Each project has an id, a name , a start date and an end date - Every employee has a name, a contact number, and an employee ID. - One Project has many employees and each employce is a member of at least one project. Also, the number of hours worked by an employee on a single project is recorded. - An employee may work for several organizations, but must work for at least one. For example, employee X may work for the Recreation Center in the morning and for the Community Center in the afternoon. Accordingly, for every employee, we must record the start and end times at each organization. - An employee may be appointed as a manager. A manager manages one or more organization(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. - An employee is either a long-term or a short-term hire and is either loeal or expatriate. Note that for local hires, CF records the end date of their contracts. (a) Consider the Manages relationship between the entities Organization and Manager. 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. (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. (c) State whether the organization ISA hierarchy has (i) covering and/or (ii) overlapping constraints. Explain briefly. (d) State whether the employee ISA hierarchy has (i) covering and/or (ii) overlapping constraints. Explain briefly. (c) Write SQL statements to create the tables corresponding to your E.R. diagram. Make sure to indicate the primary keys and the foreign keys (if any). Do not specify on delete clauses or check constraints