Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribedimage text in transcribedimage text in transcribed

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

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

Object Databases The Essentials

Authors: Mary E. S. Loomis

1st Edition

020156341X, 978-0201563412

More Books

Students also viewed these Databases questions