Please answer correctly and label them please.
1. Consider the following ERD and answer the questions that follow: EMPLOYEES EMP EMP LNAME VARCHAR 20 EMP FNAME VARCHAR O0 SALARY DEPT BUDGET MANAGERD 10 Manages BIRTH DATE OtPART PART PK (DEPT ID) PRODUCT PK (EMP ID) EMP DEPT PF* EMP ID Iger PCT TIME NUMERIC EMP DEPT PK (DEPT ID, EMP ID) 1.1) Write a CREATE TABLE SQL statement to create table EMPLOYEES. In your SQL, define a table 1.2) Write the SQL statements required to create EMP_DEPT and DEPARTMENTS, including 1.3) Write SQL statements to delete all information about employees whose salaries exceed that of constraint that will ensure that every employee makes at least $10,000. appropriate primary and foreign key integrity constraints. the manager of one or more departments that they work in. Be sure to ensure that all the relevant integrity constraints are satisfied after your updates. 2. The following is an example of a schedule of concurrent transactions: Ti ReadX) Write(X) Commit T2 T3 Read(Y) Write(Y) Commit Read(Z) Write(Z) Commit It can be written as: T1:R(X), T1:W(X), T1:Com, T2:R(Y), T2W(Y), T2:Com, T3:R(Z), T3:W(Z), T3:Com. reads objects A and B and then writes object A. Transaction T2 reads objects A and B and then writes 2.1) Write a schedule with actions of transactions T1 andT2 on objects A and B that results in a Given a database with objects A and B, assume that there are two transactions T1 andT2. Transaction T1 objects A and B. Follow the example given above, write-read conflict. Assume there is no concurrency control. write conflict. Assume there is no concurrency control. write-write conflict. Assume there is no concurrency control. 2.2) Write a schedule with actions of transactions T1 andT2 on objects A and B that results in a read- 2.3) Write a schedule with actions of transactions T1 andT2 on objects A and B that results in a 2.4) For each of the three schedules you wrote, explain how a 2-phase locking may disallow it