Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

image text in transcribedimage text in transcribedimage text in transcribed

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

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Oracle 10g SQL

Authors: Joan Casteel, Lannes Morris Murphy

1st Edition

141883629X, 9781418836290

More Books

Students also viewed these Databases questions

Question

find all matrices A (a) A = 13 (b) A + A = 213

Answered: 1 week ago

Question

What do you think the ePay Cardholder account is used for?

Answered: 1 week ago

Question

Which date of this dataset had the highest total purchase amount?

Answered: 1 week ago