Question A2. (20 marks) The table below (Table 2) lists hairdresser/customer appointment data. Each customer may have several appointments with different hairdressers at different times. Hairdresser Expertise Customer Customer AppointmentAppointment Name Peter Smith Color Peter Smith Color Maria Lee date Name John White 93146490 12-12-99 Jill Bell 95605754 12-12-99 Ian Walker 96905658 12-12-99 Jill Bell 95605754 12-10-99 14:00 John White 93146490 01-11-99 Phone time 10:00 12:00 11:00 | - Perm Robin Gong Cut Robin Gong Cut Robin Gong Cut 09:00 Jack Chu92356480 16:00 Table 2: Customer Appointment Database (a) (10 marks) The data in Table 2 is susceptible to update anomalies. Briefly explain the nature of the three forms of anomalies (insertion, deletion, and modification anomalies). Provide examples of how insertion, deletion, and modification anomalies could occur on the data in the table. I dependencies represented by the data shown in the table. State any assumptions you make about the data. (c) (6 marks) Using the functional dependencies identified in part (b) and the definitions of First Normal Form (1NF), Second Normal Form (2NF) and Third Normal Form (3NF), describe and illustrate the process of normalization by converting the table to Third Normal Form (3NF) relations. Identify the primary and foreign keys in your 3NF relations