QUESTION A2 (12 marks) Consider the Student relation schema: Student (stuID, stuName, Dept, Building, Tel, Unit, Grade, Credit) intended to contain data on students, departments, units and student's grades in units Here each student has a unique stulD, each department is in one building only and has the unique telephone number, and each unit has the unique code. The table below is a snapshot of the data held in the database stuID stuName Dept Buiding Tel Unit Grade Credit 3588 Daniel Turco COMP 7644 Tony Johnson COMP 2751 Susan RossE 2931Jane Wong COMP 3588 Denial Turco COMP 2751 Susan Ross E6A E6A Engineering E6B E6A E6A Engineering E6B 955 ISYS111 HL 955 ISYS123 D 9558 COMP115 HD 955 COMP245 F 9551ISYS125 D 9558 COMP125 P Table 1: A snapshot of student records (a) (2 marks) The data in the table is susceptible to update anomalies. Briefly explain the nature of the three forms of anomalies (insertion, deletion, and update/modification anomalies). Provide examples of how insertion, deletion, and update anomalies could occur on Table 1 (b) (10 marks) (i) Identify all functional dependencies in the Student relation in Table 1 (ii) Among all the functional dependencies identified in part (i), illustrate whether there exists any partial dependency and transitive dependency (iii) Convert the Student relation to Third Normal Form (3NF). Identify the primary and foreign keys in each new relations after normalization