[Relational data model: constraints] Suppose each of the update operations listed below is applied to the database state shown in Figure 5.6. Depending on whether there is any integrity violation by each operation, either state that there is no violation or state the integrity constraint violated and why.

a) Insert into WORKS_ON.

b) Insert into WORKS_ON.

c) Insert into WORKS_ON.

d) Insert into WORKS_ON.

e) Delete from WORKS_ON.

f) Modify to in WORKS_ON.

Figure 5.6 One possible database state for the COMPANY relational database schema. EMPLOYEE Fname Minit Lname John FranklinT Wong 333445555 1955-12-08 638 Voss, Houston, TX M 40000 8886655555 Alicia JenniferSWallace 987654321 1941-06-20 291 Berry, Bellaire, TX Ramesh K Narayan 666884444 1962-09-15 975 Fire Oak, Humble, TX M 38000 3334455555 Joyce Ahmad V Jabbar 987987987 1969-03-29 980 Dallas, Houston, TX M 25000 9876543214 James Sex |Salary_Super_ssn Dno B Smith 123456789 1965-01-09 731 Fondren, Houston, TX M 30000 333445555 5 sn Bdate Address J Zelaya 9998877771968-01-19 3321 Castle, Spring, TX F 25000 987654321 4 F 43000 888665555 A English453453453 1972-07-31 5631 Rice, Houston, TX F 25000 333445555 5 E Borg 888665555 1937-11-10 450 Stone, Houston, TXM 55000 NULL DEPARTMENT DEPT LOCATIONS Dnumber Dlocation Houston Stafford Bellaire Sugarland Houston Dname Dnumber Research Administration Headquarters Mgr ssn 333445555 987654321 888665555 Mgr start date 1988-05-22 1995-01-01 1981-06-19 4 4 WORKS ON PROJECT