Question: For the given Company database data in Figure 5.6 on page 162 of the textbook, Fundamental of Database Systems, 7th edition, (Figure 3.6 on page

 For the given Company database data in Figure 5.6 on page162 of the textbook, Fundamental of Database Systems, 7th edition, (Figure 3.6on page 72 of the 6th edition), please indicate the integrity constraint

For the given Company database data in Figure 5.6 on page 162 of the textbook, Fundamental of Database Systems, 7th edition, (Figure 3.6 on page 72 of the 6th edition), please indicate the integrity constraint violations for the following operation: Figure 5.6 One possible database state for the COMPANY relational database schema EMPLOYEE Frame Minit Lname San Bdate Address Sex Salary Super_ssn Dno John B Smith 123456789 1965-01-09 731 Fondren, Houston, TX M 30000 333445555 5 Franklin T Wong 333445555 1955-12-08 638 Voss, Houston, TX M 40000 888665555 5 Alicia J Zelaya 999887777 1968-01-19 3321 Castle, Spring, TX F 25000 987654321 Jennifer S Wallace 987654321 1941-08-20 291 Berry, Bellaire, TX F 43000 888665555 Ramesh K Narayan 666884444 1962-09-15 975 Fire Oak, Humble, TX M 38000 333445555 Joyce A English 453453453 1972-07-31 5631 Rice, Houston, TX F 25000 333445555 Ahmad Jabbar 987987987 1969-03-29 980 Dallas, Houston, TX M 25000 987654321 James E Borg 888665555 1937-11-10 450 Stone, Houston, TX M 55000 NULL 1 4 4 Dnumber DEPARTMENT Dname Research Administration Headquarters 5 Mgr_ssn 333445555 987654321 888665555 Mgr_start_date 1988-05-22 1995-01-01 1981-06-19 4 DEPT_LOCATIONS Dnumber Dlocation 1 Houston 4 Stafford 5 Bellaire 5 Sugarland 5 Houston 1 WORKS ON Esan Pro Hours Pnumber Plocation Dnum 1 1 5 123456789 123456789 32.5 7.5 2 5 PROJECT Pname ProductX ProductY Productz Computerization Reorganization Newbenefits 2 3 666884444 3 40.0 Bellaire Sugarland Houston Stafford Houston 5 1 20.0 10 4 453453453 453453453 2 20 1 2 20.0 10.0 10.0 30 Stafford 333445555 333445555 4 3 10 DEPENDENT 333445555 333445555 10.0 10.0 20 Essn Dependent_name Sex F 999887777 30 30.0 Alice 10 999887777 987987987 333445555 333445555 333445555 10.0 35.0 5.0 M F 10 Bdate Relationship 1986-04-05 Daughter 1983-10-25 Son 1958-05-03 Spouse 1942-02-28 Spouse 1988-01-04 Son 1988-12-30 Daughter 1967-05-05 Spouse 987987987 30 Theodore Joy Abner Michael Alice 987654321 M 987654321 30 20.0 123456789 M 987654321 20 F 15.0 NULL 123456789 123456789 888665555 20 Elizabeth F Select the following correct options for each. a Violating referential integrity constraint b. Violating both key constraint and referential integrity constraint c. No violation of integrity constraint d. Violating key constraint Questions are: 1.Insert into DEPARTMENT. 2. Insert Robert', 'F', 'Scott', '943775543', '1952-06-21, 2365 Newcastle Rd, Bellaire, TX', 'M', 58000, '888665555, 1> into EMPLOYEE 3.Insert Producta, 4, 'Bellaire', 2> into PROJECT. 4. Insert 3677678989, null, "40.0'> into WORKS_ON. 5. Insert into DEPENDENT. 6. Delete the WORKS_ON tuples with ESSN 2333445555'. 7. Delete the EMPLOYEE tuple with SSN:987654321'. 8. Delete the PROJECT tuple with PNAMES Products 9. Modify the MGRSSN and MGRSTARTDATE of the DEPARTMENT tuple with DNUMBER = 5 to '123456789' and '1999-10-01', respectively. 10. Modify the SUPERSSN attribute of the EMPLOYEE tuple with SSN = "999887777' to '943775543 11. Modify the HOURS attribute of the WORKS_ON tuple with ESSN 2999887777 and PNO = 10 to '5.0

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!