This is an introduction to database question

Explain briefly why a table whose primary key consists of a single attribute automatically is in the 2NF when it is in the INF. 12 marka b. Table 1 shows the details of some rooms leased by students of the University Bas. A place number (placeNo) uniquely identifies each single room in all the sand is used when leasing a room to student Table 1: die band place there whee 201706 1 /09/2010 2011 206 10121349 1 /09/2010 3521116 30212501786 new 1/09/2011 3 /2012 3036413999 Tome 1/9/2011 /06/2012 3 13 ore 2012124 102 Karen Back 1/09/2011 10/06/2012 29120 an y 1014511 Steven Smith 1/09/2012 /06/2013 ore 13160801339978 Tom Jones 1/03/2012 30/06/2013 16 h EXAMINERS: GEORGE KODJO ANNI 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. (1) 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). (1) Using the functional dependencies identified in 35.00), convert the table to 3NF. In each of the derived tables in (NF) indicate the primary keys and the foreign keys Note: Show tables with values [18 marks) List and briefly discuss the five transaction properties 15 marks] 118 marka & Explain briefly why a table whose primary key consists of a single attribute automatically is in the 2NF when it is in the INF. 12 marka b. Table 1 shows the details of some rooms leased by students of the University Bas. A place number (placeNo) uniquely identifies each single room in all the sand is used when leasing a room to student Table 1: die band place there whee 201706 1 /09/2010 2011 206 10121349 1 /09/2010 3521116 30212501786 new 1/09/2011 3 /2012 3036413999 Tome 1/9/2011 /06/2012 3 13 ore 2012124 102 Karen Back 1/09/2011 10/06/2012 29120 an y 1014511 Steven Smith 1/09/2012 /06/2013 ore 13160801339978 Tom Jones 1/03/2012 30/06/2013 16 h EXAMINERS: GEORGE KODJO ANNI 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. (1) 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). (1) Using the functional dependencies identified in 35.00), convert the table to 3NF. In each of the derived tables in (NF) indicate the primary keys and the foreign keys Note: Show tables with values [18 marks) List and briefly discuss the five transaction properties 15 marks] 118 marka &