Exercise 2 Consider the following relation with sample data. AIRPORTS AND GATES TABLE Some of the requirements that this table is based on are as follows: - Each airline has a unique AirlineName and an AirlineNumberOfEmployees - Each airport has a unique AirportID and a name of the city (AirportCity) where it is located. - Each city has (one, of course) CityPopulation. - A city can have more than one airport. - Each airport assigns certain number of gates (NumberOfGatesAssigned) to the airlines that serve it. Exercise 2-a Using the AIRPORTS AND GATES Table, describe examples that illustrate the insertion anomaly, deletion anomaly, and modification anomaly. (0.3pt) Exercise 2-b Depict full key functional dependencies, partial functional dependencies (if any), and transitive functional dependencies (if any) in the AIRPORTS AND GATES Table. (0.3 pt) Exercise 2-c Show the result of normalizing the AIRPORTS AND GATES Table to 2NF. (0.2 pt) Exercise 2-d Show the result of normalizing the AIRPORTS AND GATES Table to 3 NF. (0.2 pt)