need help with a and b

QUESTION A2 (10 marks) Consider the relation schema: Borrowings (accNo, Author, pYear, sID, sName, iDate, Library, Building) intended to contain data on books that student borrow from different libraries at Kafka University. A book is identified by its accession number, is written by a single author published in a particular year, and is issued to a student on some date at a particular library. The table below is a snapshot of the data held in the database accNo Author pYear SID SName iDate LibraryBuilding C2345Shakespeare 1602 12345 John 1/6/2016Central Clinton 8/6/2016 Centra Clinton C1234Newton 1728 12345John 15/ Central Clinton 1/6/2016 Classics Obama 22/6/2016 Classics Obama lassicsObama C2345 Shakespeare 16 0213300 Jack /6/2016 02341 |Shakespeare 16 02341 Shakespeare 16 02314 Newton 02 14444 Jill 0212345John22 172815555Jane Table 1: Borrowing Record of books from different libraries at Kafka University (a) (5 marks) The data in the table is susceptible to update anomalies. Briefly explain the nature of the three forms of anomalies (insertion, deletion, and update/modification anomalies). Provide examples of how insertion, deletion, and update anomalies could occur on Table 1 (b) (5 marks) (i) Identify the functional dependencies based on your understanding of how libraries function at the Kafka University. Explain how the data in Table 1 satisfy those dependencies. State any assumptions you have made. (ii) Did you identify Author p Year as one of the functional dependencies above? Justify why you did, or did not, do so. (iii) Using the functional dependencies identified in part (i) above, describe and illustrate the process of normalization by converting the Borrowings relation to Third Normal Form (3NF). Identify the primary and foreign keys in these relations in 3NF that you obtained