deletion/update anomalies question

Consider the Branch (with primary key: branchNo) and Staff (with primary key: staffNo & foreign key: branch No) tables shown below and answer the following questions. Branch branchNo street city postcode B005 22 Deer Rd London SW14EH 16 Argyll St Aberdeen AB2 3U B003 163 Main St Glasgow G11 9QX BS99 INZ BOO2 56 Clover Dr London NW10 6EU B007 B004 32 Manse Rd Bristol Staff staffNo Name Name position sex DOB salary branch No SL21 John White Manager M 1-Oct-45 30000 BOOS SG37 Ann Beech Assistant F 10-Nov-60 12000 BO03 SG14 David Ford Supervisor M 24-Mar-5818000 B003 SA9 Mary Howe Assistant F 19-Feb-70 9000 B007 SG5 Susan Brand Manager F 3-Jun-40 24000 B003 SL41 Julie Lee Assistant F 13-Jun-65 9000 B005 In your own words, compare the difference between entity integrity & referential integrity. Illustrate with the help of tables above, how a referential integrity constraint will prevent user from entering inconsistent data record? (8 marks) (b) A major aim of relational database design is to group attributes into relations to minimize data redundancy hence to avoid the database anomalies. Consider the StaffBranch (with primary key: staffNo) table below to answer the following questions. Staff Branch staffNosName position salary branch NobAddress John White Manager 30000 B005 22 Deer Rd, London Ann Beech Assistant 12000 B003 163 Main St, Glasgow David Ford Supervisor 18000 B003 163 Main St, Glasgow Mary Howe Assistant 9000 B007 16 Argyll St, Aberdeen Susan Brand Manager 24000 B003 163 Main St, Glasgow Julie Lee Assistant 9000 B005 22 Deer Rd, London SL21 SG37 SG14 SA9 SGS SL41 (i) Explain in your own words what is meant by insertion anomaly. Describe, with reference to the table above, a situation where an insertion anomaly could occur. (6 marks) Explain in your own words what is meant by deletion anomaly. Describe, with reference to the table above, a situation where a deletion anomaly could occur. (ii)