QUESTION 3 Table 5 lists patient appointment data with the dentists. A patient is given an appointment with a dentist at a specific time, date and a surgery room. On each day of patients' appointment, a dentist is allocated to a specific surgery room (i.e. column surgeryNo) for that day. Table 5: Dentist/Patient Appointment Data stato dentistName Patiento PatientName appointment Date appointment Time surgeryNo S1011 P101 Foon Yew 09 Nov 2014 8.30 am sis S1011 P105 09 Nov 2014 9.30 am 15 S1022 Ahmad Zulhilmi Ahmad Zulhilmi Plevin Cruze Plevin Cruze Mary Anne P108 09 Nov 2014 8.30 am s10 S1022 P108 11 Nov 2014 2.00 pm s10 Saodah Hathim Winstor Yee Winstor Yee Saodah Hathim Siti Sabariah S1030 P105 11 Nov 2014 3.00 pm sis S1030 Mary Anne P105 12 Nov 2014 4.00 pm s13 a) Based on the above explanation, answer the following questions: a) Table 5 is susceptible to update anomalies. Provide ONE example for each of insertion, deletion, and update anomalies. b) Identify in what level of Normal Form the Table 5 is in. Justify your answer. c) Identify the Primary key (PK) for Table 5. d) Identify all functional dependencies that can be derived from the Table 5. e) Illustrate the process of normalizing Table 5 up until Boyce Codd Normal Form (BCNF) level. State any assumptions you make about the data shown in the table