total marks 10) What ( update, (il) delete and insertion anomalies occur in the DEPARTMENT PROJECT relation obtained by doing a form of natural join of the two relations DEPARTMENT and PROJECT of Fig 14.2 on page 463 of book? Explain with examples using this database and the DEPARTMENT PROJECT relation schema with state given below as Figures 4.1 and 4.2 below. (Total for que 4 s 10 marks) Note: 3 marks for correct discussion of each anomaly and 1 mark for attempt. Figure 14.2 (book): Sample database state for a simplified COMPANY relation DB EMPLOYEE Sun B date Addres Smith J B 1234567891065-01-00 731 Fonden Houston TX Wong, Franklin 333445555 1955-12-08 638 Voss Houston, TX Zely Alicia 99887727 1968-07-19 3321 Case Seine, TX Wilce, Jens 9876543211941-06 20 201 Barry, B TX R K666884444 1962-0015975 FC Hub TX Engl Joyas A 4 53453453 1972-07-31 5631 Re Houston, TX Jubb AndV 8 7987907 1909-03-20 980 Dallas, Houston, TX Bog E 6 666555 1937-11-10 450 Stone, Houston, TX N DEPT LOCATIONS DEPARTMENT Deuter Dmgr son 333445555 Administration 4 987654321 Headquarters 1 BB8665555 WORKS ON Dnum 325 Pumber Plocation Baina 2 Sugarland 123456789 193456789 666884444 453453453 453453453 PROJECT Prame ProductX ProductY | Productz Computeration Reorganization Newbenefits 900 10 20 30 Stafford H ouston Stafford 333445565 333445555 10.0 100 100 333445555 98790907 30 200 75421 88866566620 N Fig 4.1: DEPARTMENT_PROJECT DB schema suffering from update anomalies Doumbes Pnumber Roare Dmer san Pname. Plocation FOLT Fig 4.2: A database state of the DEPARTMENT PROJECT DATABASE derived from Fig 14.2 DNUMBER PNUMBER DNAME DMGR_SSN PNAME PLOCATION 10 Research 333445555 Productz Houston Research 333445555 Computerize Stafford Research 333445555 Reorganize Houston Research 333445555 Nbeoefits. Stafford Research 333445555 Product Bellaic Research 333445555 Product Sugarland Administration 987654321 ProductZ Houston Administration 987654321 Computerize Stafford Administration 987654321 Reorganize Houston Administration 987654321 Nbenefits. Stafford Administration 987654321 Product Bellaic Administration 987654321 Product Sugarland Headquarters 888665555 Product Houston Headquarters 888665555 Computerize Stafford Headquarters 888665555 Reorganize Houston Headquarters 888665555 benefits. Stafford Headquarters 888665555 Product Bellair Headquarters 888665555 Product Sugarland 1 10 120 1 30 1 1 1 2 18 rows selected