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 Library Building C2345 Shakespeare 160212345 John 1/6/2016 Centra Clinton C2345 Shakespeare 1602 13300Jack 8/6/2016 Central Clinton ton 1/6/2016Classics Obama 02341 Shakespeare 1602 2345 John 22/6/2016 Classics Obama 1728 15555 Jane 2 Classics Obama C1234 Newton172812345 John 15/6/2016 Central 02341 Shakespeare 160 2 14444 Jill 02314 Newton 22/6/2016 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