Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Identify all the integrity constraints (if any) that will be violated if we perform the following operations. If a constraint is violated (a) explain briefly
Identify all the integrity constraints (if any) that will be violated if we perform the following operations. If a constraint is violated (a) explain briefly why this happens, and (b) suggest all possible actions to be taken for correcting the cause of the violation of the constravai (1) Insert into EMPLOYEE (2) Insert into PROJECT (3) Delete the PROJECT tuple(s) with PNAME -Computerization' 4) Delete the WORKS_ON tuples with PNO 8. (5) Update the SSN and the SALARY of the EMPLOYEE tuple(s) with DNO = 1 to 333445555' and 55000 respectively. (6) Update the SSN and the SUPERSSN of the EMPLOYEE tuples) with LNAME- Jabbar to 112233445' and NULL respectively. EMPLOYEE FNAME MINIT LNAME SSN BDATE ADDRESS SEX SALARY DNO DEPARTMENT DNUMBER MGRSSN MGRSTARTDATE DEPT LOCATIONS DLOCATION PNAME PNUMBER PLOGATION DNUM WORKS ON ESSN PNO HOURS ESEN DEPENDENT NAME SEX BDATE RELATIONSHIP Figure 1 One possible relational database state corresponding to the coMPANY schema. EMPLOYEE FNAME MINITLNAME SEXI SALARY ISI PERSN 123456789 1965-01-09 333445555 1955-12-08 Zooja 1990887777 1968-01-10 Walace 9876543211941-06-20 Narayan 666884444 1982-09-15 453453453 1972-07-31 987987987 1969 03-29 Frankin T Wong 638 Voss, Houston, TX 2221 Carte Spring, TX 91 Bemry, Belare TX 5631 Rice, Houston, TX 980 Dalas, Houston, TX 987854321 1907-11- DNAME Research 1988-05-22 WORKS ON PNO HOURS 7.5 200 PNUMBER PLOGATION ONUM Houston 333445555 20 100 35.0 SOTETEO7 200 987654321 20 DEPENDENT NAME SEx 1983-10-25 SON 123456789 Mcnbel 1988-01-04 1988-12-30 SON
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