b. Table 1 shows the details of some rooms leased by students of the University flats. A place number (placeNo) uniquely identifies each single room in all the flats and is used when leasing a room to student. Table 1: leasello bannerid placele Name Name startDate finishDate flat No flatAddress 100030017706 Jane Watt 1/09/2010 30/06/2011 156 34 High Stree, Paisley 10003 801212479 Karen Black 1/09/2010 30/06/2011 56 34 High Stree, Paisley 10259 0017705 Jane Want 1/09/2011 30/06/2012 778 111 Store Road Paisley 30364 013999 89 ones1/09/2011 30/06/2012 778 111 Storie Road Paisley 10566 3017124 102 Karen Black 1/09/2011 30/06/2012 F19 120 Lady LanePaisley 11067 3034511 Smith 1/09/2012 30/06/2013 F78 1 11 Starrin Road, Paisley 113698013399 78 Jones 1/09/2012 30/06/2013 56 4 High Stree, Paisley CAMINERS: GEORGE KODJO ANNT AND ISAAC K. NTI Page 2 of 4 (1) The table shown above is susceptible to update anomalies. Provide examples of how insertion, deletion, and modification anomalies could occur on this table. (ii) Identify the functional dependencies that exist between the columns of the table and primary key (PK) and any alternative key(s) (if present for the table). (iii) Using the functional dependencies identified in 3.b.(1), convert the table to 3NF. In each of the derived tables in (3NF) indicate the primary keys and the foreign keys. [Note: Show tables with values] [18 marks] c. List and briefly discuss the five transaction properties 15 marks]