3. (c) The table shown in Figure 14.23 is susceptible to update anomalies. Provide examples of how insertion, deletion, and modification anomalies could occur on this table. applying normalisation to 3NF on the table shown in Figure 14.23 results in the formation of he four tables shown in Figure 14.24. Figure 14.24 Tables (in 3NF) displaying sample data of university accommodation. 1. (a) Identify the functional dependencies that exist between the columns of each table in Figure 14.24 and identify the primary key and any alternate and foreign key(s) (if present) for each table. 2. (b) Describe why storing the university accommodation data across four 3NF tables avoids the update anomalies described in Exercise 14.19 (b). 3. (c) Describe how the original table shown in Figure 14.23 can be re-created through relational joins between primary key and foreign keys columns of the tables in Figure 14.24