Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Suppose each of the following Update operations is applied directly to the database of above Figure, Discuss all integrity constraints violated by each operation, if
Suppose each of the following Update operations is applied directly to the database of above Figure, Discuss all integrity constraints violated by each operation, if any, and the different ways of enforcing these constraints
- Insert
Bellaire, TX, M, 58000, 888665555, 1> into EMPLOYEE. - Insert
into PROJECT. - Insert
into DEPARTMENT. - Insert NULL, 40.0> into WORKS_ON.
- Insert into DEPENDENT.
- Delete the WORKS_ON tuples with Essn = 333445555.
- Delete the EMPLOYEE tuple with Ssn = 987654321.
- Delete the PROJECT tuple with Pname = ProductX.
- Modify the Mgr_ssn and Mgr_start_date of the DEPARTMENT tuple with Dnumber = 5 to 123456789 and 2007-10-01, respectively.
- Modify the Super_ssn attribute of the EMPLOYEE tuple with Ssn = 999887777 to 943775543.
- Modify the Hours attribute of the WORKS_ON tuple with Essn = 999887777 and Pno = 10 to 5.0.
Dno 5 5 4 EMPLOYEE Fname Minit John B Franklin T Alicia J Jennifer S Ramesh Joyce Ahmad V James E 4 5 5 4 1 DEPARTMENT Dname Research Administration Headquarters 1 WORKS ON Essn Lname Ssn Bdate Address Sex Salary Super_ssn Smith 123456789 1965-01-09 731 Fondren, Houston, TX M 30000 333445555 Wong 333445555 1955-12-08 638 Voss, Houston, TX M 40000 888665555 Zelaya 999887777 1968-01-19 3321 Castle, Spring, TX F 25000 987654321 Wallace 987654321 1941-06-20 291 Berry, Bellaire, TX F 43000 888665555 Narayan | 666884444 1962-09-15 975 Fire Oak, Humble, 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 DEPT_LOCATIONS Dnumber Mgr_ssn Mgr_start_date Dnumber Dlocation 5 333445555 1988-05-22 1 Houston 4 987654321 1995-01-01 4 Stafford 888665555 1981-06-19 5 Bellaire 5 Sugarland 5 Houston PROJECT Pno Hours Pname Pnumber Plocation Dnum 1 32.5 ProductX 1 Bellaire 5 2 ProductY 2 Sugarland 5 3 40.0 Productz 3 Houston 5 1 20.0 Computerization 10 Stafford 4 2 20.0 Reorganization 20 Houston 1 2 10.0 Newbenefits 30 Stafford 4 3 10.0 10 10.0 DEPENDENT 10.0 Essn Dependent_name Sex Bdate Relationship 30.0 333445555 Alice F 1986-04-05 Daughter 10 10.0 333445555 Theodore M . 1983-10-25 Son 10 35.0 333445555 Joy F 1958-05-03 Spouse 5.0 987654321 Abner M 1942-02-28 Spouse 20.0 123456789 Michael M . 1988-01-04 Son 20 15.0 123456789 Alice F 1988-12-30 Daughter 20 NULL 123456789 Elizabeth 1967-05-05 Spouse 123456789 123456789 7.5 666884444 453453453 453453453 333445555 333445555 333445555 333445555 999887777 999887777 987987987 987987987 987654321 987654321 888665555 F
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started