(Solved) : Execute Following Query Db Display Discuss Integrity Constraints Violated Following Operat Q30580839 . . . .

Execute the following Query on theDb to display and discuss the integrity constraints violated by anyof the following operations

1. Insert(‘Robert’, ‘F’, ‘Scott’, ‘943775543’, ’21-JUN-42′, ‘2365 NewcastleRd, Bellaire, TX’, M, 58000, ‘888665555’, 1 ) intoEMPLOYEE.
2. Insert ( ‘677678989’, null, ‘40.0’ ) into WORKS_ON.
3. Insert ( ‘453453453’, ‘John’, M, ’12-DEC-60′, ‘SPOUSE’ ) intoDEPENDENT
4. Delete the WORKS_ON tuples with ESSN= ‘333445555’.
5. Modify the MGRSSN and MGRSTARTDATE of the DEPARTMENT tuple withDNUMBER=5 to ‘123456789’ and ’01-OCT-88′, respectively.

Alter thetables to

1. Add Foreign Keysusing Alter Table [if not done earlier].
2. Drop Foreign key defined on SuperSSN and add it using Altertable