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 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

Database Processing Fundamentals Design And Implementation

Authors: KROENKE DAVID M.

1st Edition

8120322258, 978-8120322257

More Books

Students also viewed these Databases questions

Question

How does MRP II differ from MRP?

Answered: 1 week ago

Question

Where does the value of p0 come from when stating H0?

Answered: 1 week ago