| |

Question: Suppose that each of the following Update operations is applied directly to the database state shown in Figure 3.6. Discuss all integrity constraints vio­ lated by each operation, if any,and the different ways of enforcing these con­ straints. – Free Chegg Question Answer

(4 bookmarks)

Flag

3.11. Suppose that each of the following Update operations is applied directly to

the database state shown in Figure 3.6. Discuss all integrity constraints vio­

lated by each operation, if any,and the different ways of enforcing these con­

straints.

a. Insert <‘Robert’F’,’Scott’, ‘943775543’, ‘1972-06-21’2365 Newcastle Rd, Bellaire, TXM, 58000,’888665555’, 1> into EMPLOYEE.

b. Insert <‘ProductA’, 4,’Bellaire’, 2> into PROJECT.

c. Insert <‘Production’, 4,’943775543’2007-10-01′> into DEPARTMENT. d. Insert <‘677678989NULL, ‘40.0’> into WORKS_ON.

e. Insert <‘453453453’John’, ‘M’, ‘1990-12-12’spouse’> into DEPENDENT.

f. Delete the WORKS_ON tuples with Essn = ‘333445555:

g. Delete the EMPLOYEE tuple with Ssn = ‘987654321’. h. Delete the PROJECT tuple with Pname = ‘ProductX’.

i. Modify the Mgr_ssn and Mgr_start_date of the DEPARTMENT tuple with

Dnumber = 5 to ‘123456789’and ‘2007-10-01respectively.

j. Modify the Super_ssn attribute of the EMPLOYEE tuple with Ssn =

‘999887777’ to ‘943775543’.

k. Modify the Hours attribute of the WORKS_ON tuple with Essn =

‘999887777’ and Pno = 10 to ‘5.0’.

uploaded image
Transcribed text From Image:

Expert Chegg Question Answer:

free chegg question answer
Smart Teacher From Answerie.com
Answer:

Answer


<img src="https://media.cheggcdn.com/study/8f2/8f25ea0c-9b2d-4fc6-b526-dca74b5e0a8a/ca6f9288-abc0-4058-a07c-a1cffca97602.png" alt="a. Insert
d. nse 677678939 i. 400> into WORKS ON: This insertion violates the entity integrity constraint ( for the pnmary key PNO) A
This deletion is not acceptable because tuples in EMPLOYEE, DEPARTMENT. WORKS ON and DEPENDENT refer to this tuple Hence, if
to 943775543 This modification satises all constraints, so it is acceptable SSN-943775543 was inserted properly into the data

Free Chegg Question Answer

Leave a Reply

Your email address will not be published. Required fields are marked *