(Solved) : 2 10 Points Suppose Following Update Operations Applied Directly Database State Shown Di Q31100839 . . . .

2). (10 points) Suppose that each of the following Updateoperations is applied directly to the database state shown below.Discuss all integrity constraints violated by each operation, ifany.

a). Insert <‘Robert’, ‘F’, ‘Scott’, NULL, ‘1972-06-21’, ‘2365Newcastle Rd, Bellaire, TX’, M, 58000, NULL, 6> intoEMPLOYEE.

b). Delete the WORKS_ON tuples with Essn = ‘123456789’.

c). Modify the SUPERSSN attribute of the EMPLOYEE tuple withSSN= ‘999887777’ to ‘943775543’.

d). Insert <‘Research’, 5, ‘333445555, ‘1988-05-22’> intoDEPARTMENT.

e). Delete the EMPLOYEE tuple with Ssn = ‘987654321’.

Answer the question by checking the corresponding cellin the following table.

Domain violation

Key violation

Entity integrity violation

Referential integrity violation

2a.2b.2c.2d2e

Expert Answer

An answer will be send