Database

L 3. Suppose that each of the following Update operations is applied directly to the database state shown in Figure 5.6. Discuss all integrity constraints violated by each operation, if any, and the different ways of enforcing these constraints. a. Insert into DEPARTMENT. b. Insert into WORKS ON. c. InsertintoDEPENDENT. d. Delete the PROJECT tuple with Pname = 'ProductX'. e. Modify the Mgr_ssn and Mgr_start_date of the DEPARTMENT tuple with Dnumber= 5 to '123456789' and '2007-10-01', respectively. f. Modify the Hours attribute of the WORKS ON tuple with Essn 999887777' and Pno= 10 to '5.0'. One possibIO Outub stato for to dawno sanom EMPLOYEE Minit B Dno T 5 J Frame John Franklin Alicia Jennifer Ramesh Joyce Ahmad S name Son Bdato Address Sex Salary Super_san Smith 123456789 1906-01-09 731 Fondron, Houston, TX M 30000 333445555 Wong 333445655 1956-12-08 639 Voss, Houston, TX M 40000 888885555 Zelaya 999087777 1968-01-19 3321 Castlo, Spring, TX F 25000 987654321 Wallace 987654321 1941-08-20 291 Berry, Bellaire, TX F 43000 BBB885555 Narayan6668844441962-09-15 075 Fire Oak, Humblo, TX M 38000 333445555 English 453453453 1972-07-31 5631 Rice, Houston, TX F 25000 333445555 Jabbar 987987987 1969-03-29 980 Dallas, Houston, TX M 25000 987654321 Borg 888665555 1937-11-10 450 Stone, Houston, TX M 55000 NULL 5 A 5 V 4 James E 1 DEPARTMENT Dnamo Dnumber Mgr_start_date 5 Mgr_ssn 333445555 987654321 Research Administration Headquarters 1988-05-22 4 1995-01-01 DEPT LOCATIONS Dnumber Dlocation 1 Houston 4 Stafford 5 Bellaire 5 Sugarland 5 Houston 1 888665555 1981-06-19 PROJECT WORKS ON Essn Pno Hours Pnumber Dnum 1 1 Pname ProductX ProductY 123456789 123456789 5 32.5 7.5 Plocation Bellaire Sugarland Houston 2 2 5 666884444 3 40.0 3 5 453453453 1 20.0 10 4 ProductZ Computerization Reorganization Newbenofits 2. 20 453453453 333445555 1 Stafford Houston Stafford 20.0 10.0 2 30 4 333445555 3 10.0 333445555 10 10.0 DEPENDENT 333445555 10.0 Essn Sex 999887777 30 30.0 F 10 10.0 999887777 987987987 333445555 333445555 333445555 M 8 8 8 8 8 8 W Dependent_name Alice Theodoro Joy Abner Bdate 1986-04-05 1983-10-25 1958-05-03 1942-02-28 Relationship Daughter Son Spouse Spouse 10 35.0 F 30 5.0 987654321 M 987987987 987654321 30 20.0 M 1988-01-04 Son Michael Alice 987654321 123456789 123456789 123456789 15.0 F 1988-12-30 Daughter Spouse 888665555 NULL Elizabeth F 1967-05-05 One possible database state for the COMPANY relational database schema EMPLOYEE Fname Minit Lname Ssn Bdate Address Dno Sex Salary M 30000 Super_san 333445555 John Smith 123456789 5 Franklin M 40000 888665555 5 Alicia T J S Wong 333445555 Zelaya 999887777 Wallace 987654321 F 25000 987654321 4 Jennifer F 43000 888665555 4 1965-01-09 731 Fondren, Houston, TX 1955-12-08 638 Voss, Houston, TX 1988-01-19 3321 Castle, Spring, TX 1941-06-20 291 Berry, Bellaire, TX 1962-09-15 975 Fire Oak, Humble, TX 1972-07-31 5631 Rice, Houston, TX 1969-03-29 980 Dallas, Houston, TX 1937-11-10 450 Stone, Houston, TX Ramesh K M 38000 333445555 5 Narayan 666884444 English 453453453 Jabbar 987987987 F Joyce Ahmad 25000 333445555 5 M 25000 987654321 4 James E Borg 888665555 M 55000 NULL 1 DEPARTMENT DEPT_LOCATIONS Dname Dnumber Dnumber Dlocation Mgr_ssn 333445555 Mgr_start_date 1988-05-22 Research 5 1 Houston Administration 987654321 1995-01-01 4 Stafford Headquarters 1 888665555 1981-06-19 5 Bellaire 5 Sugarland 5 Houston