need help with part b and c

Consider the relation schema: Enrolment (Dept, UnitNo, Offering, SID, SName, EnDate, CName, CLoc) intended to contain studen enrolment data for My University, a multi-campus university with different campuses around Sydney. The campus name is represented as CName and campus location as CLoc. A u is offered by a particular department, is taught at a particular campus, and a student must enrol in it for a particular offering by a given dat.e The table below is a snapshot of the data held at some particular time Dept UnitNo Offering SID SName EnDate CName CLoc Computing Isys224 2015S2 12345 John 1/6/2015 MaiNorthRyde Computing Isys114 2015S 12345 John 1/1/2015 SIBT NorthRyde Man NorthRyde Economics Econ213 2015S2 12345 John 1/6/2015 Mai NorthRyde Economics Econ223 2015S2 21324 Jack 1/6/2015 CityC CBD Computing Isys224 2015S2 21325 Jill Economics Econ123 2015S121325Jill 1/6/2015 2/1/2015 CityCCBD Table 1: Enrolment at My University (a) (5 marks) The data in the table is susceptible to update anomalies. Briefly explain the nature of the three forms of anomalies (insertion, deletion, and modification anoma- lies). Provide examples of how insertion, deletion, and modification anomalies could occur on Table 1 (b) (3 marks) (i) Identify the functional dependencies based on your understanding of the My University domain. Explain how the data in Table 1 satisfy those dependencies State any assumptions you have made Did you identify Unit No ( Justify why you did, or did not, do so (ii) ering as one of the functional dependencies above? (c) (2 marks) Using the functional dependencies identified in part (b) above, describe and illustrate the process of normalization by converting the Enrolment relation to Third Normal Form (3NF). Identify the primary and foreign keys in these relations in 3NF that you obtained