It's Database Concepts

Only Do D,Hand I from 5.11 and do whole 5.15

5.11 Supposed that each of the following Update operations is applied directly to the database state shown in the Figure 3.6. Discuss all integrity constraints violated by each operation, if any, and the different ways of enforcing these constraints. a. Insert into EMPLOYEE. b. Insert into PROJECT. c. Insert into DEPARTMENT. d. Insert into WORKS ON. e. Insert into DEPENDENT. 1. 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-01, respectively. 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'. 5.15 Consider the following relations for a database that keeps track of business trips of salespersons in a sales office: SALESPERSON (Ssn. Name, Start_year, Dept_no) TRIP(Ssn, From_city, To_city, Departure_date, Return_date, Trip id) EXPENSE(Trip id, Account# Amount) A trip can be charged to one or more accounts. Specify the foreign keys for this schema, stating any assumptions you make