Suppose that each of the following update operations is applied directly to the database state shown in the Figure 1. Discuss all the integrity constraints violated by each operation, if any, and the different ways of enforcing these constraints.

Insert into EMPLOYEE.

Insert into PROJECT

Insert into DEPARTMENT

Insert into WORKS_ON.

Insert into DEPENDENT.

Delete the WORKS_ON tuples with Essn=333445555.

Delete the EMPLOYEE tuple with Ssn= 987654321.

Delete the PROJECT tuple with Pname=ProductX.

Modify the MGR_ssn and Mgr_start_date of the DEPARTMENT tuple with Dnumber=5 to 123456789 and 1999-10-01, respectively.

Modify the Hours attribute of the WORK_ON tuple with Essn= 999887777 and Pno=10 to 5.0.

e possible database state for the COMPANY relational database schema. EMPLOYEE Bdate Sex Salary Super ssn Dno Fname Minit Lname John B Smith 123456789 1965-01-09 731 Fondren, Houston, TX M 30000 333445555 5 Frankin T Wong 333445555 1955-12-08 638 Voss, Houston TXM 4 AliciaZelaya 999887777 1988-01.19 3321 Castie, Spring, TX F 25000 987654321 4 ennifer S Walace 987654321 1941-06-20 291 Bery Bellir, TX F 43000 8886655554 Ramesh K Narayan 666884444 1962-09-15 975 Fire Oak, Humble, TX M 38000 3334455555 Joyce A English 453453453 1972-07-31 5631 Rice, Houston, TX F 25000 3334455 Ahmad V Jabbar 987987987 1969-03-29 980 Dallas, Houston, TX M 25000 9876543214 Address 40000 888665555 5 83 ames E Borg 88665555 1937-11.10 450 Stone, Houston.TX M 56000 NULL DEPT LOCATIONS DEPARTMENT Dnumber 1 Mgr-start-dat DnumberDlocation | 333445555 1988-05-22 Mgr-ssn Houston Stafford Bellaire 987654321 1995-01-01 5 Headquarters 888665555 1981-06-19 5 PROJECT WORKS ON Pnumber Plocation Dnum Pname ProductX ProductY Pno Hours Essn 123456789 123456789 666884444 3 5 32.5 7.5 40.0 20.0 2 Sugarland5 5 Computerization 10 Stafford Reorganization20Houston Newbenefits 453453453 453453453 2 20.0 333445555 30 Stafford 10.0 3334455553 10.0 333445555 1010.0 333445555 20 999887777 999887777 10 10.0 987987987 987987987 987654321 987654321 888665555 20NULL DEPENDENT 10.0 Dependent name SexBdate Essn 333445555 Alice 333445555 Theodore 333445555 Joy 987654321 Abner 123456789 Michael 123456789 Alice 123456789 Elizabeth F 1986-04-05 Daughter M 1983-10-25 Son F 195805-03 Spouse M 1942-02-28 Spouse M 1988-0104Son F 1988-12-30 Daughter F 19670505 Spouse 30 30.0 10 35.0 30 30 20.0 20 15.0 5.0