Answered step by step
Verified Expert Solution
Link Copied!
Question
1 Approved Answer

In class we have discussed four types of Integrity Constraints: Domain Constraint, Key Constraint, Entity Integrity Constraint and Referential Integrity Constraint. Suppose that each of

image text in transcribed
image text in transcribed
image text in transcribed
In class we have discussed four types of Integrity Constraints: Domain Constraint, Key Constraint, Entity Integrity Constraint and Referential Integrity Constraint. Suppose that each of the following data change operations is applied directly to our COMPANY database, whose schema and instance are shown in Figures and 2 respectively. 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 constraint. a nd isianeare (1) Insert into EMPLOYEE (2)Insert into PROJECT. (3) Delete the PROJECT tuple(s) with PNA ME = 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 tuple(s) with LNAME Jabbar to '112233445' and NULL respectively. EMPLOYEE DEPARTMENT DEPT LOCATION INUMEER PLOCATION ONUM DEPENDENT ESSN DEPENDENT NAME RELATIONOP Figure 1 One possible relational database state corresponding to the coMPANY schema BOATE DEPT TOC NAME Figure 2

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_2

Step: 3

blur-text-image_3

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

Advanced Oracle Solaris 11 System Administration

Authors: Bill Calkins

1st Edition

0133007170, 9780133007176

More Books

Students explore these related Databases questions