2) Consider the following relation: AIRPORTS AND GATES AirlineNumberOf NumberOfGates AirportID AirportCity CityPopulation ORD Chicago, IL 3.1 million AirlineName United Employees Assigned 20000 12 ORD Chicago, IL 3.1 million Jet Blue 6000 2 ORD Chicago, IL 3.1 million American 22000 10 ATL Atlanta, GA 1.2 million Delta 17000 12 ATL Atlanta, GA 1.2 million Jet Blue 6000 3 LAX Los Angeles, CA 4.0 million United 20000 10 MDW Chicago, IL 3.1 million Delta 17000 3 MOW Chicago, IL 3.1 million Southwest 20000 15 Some of the requirements that this table is based on are as follows: Each airline has a unique AirlineName and an AirlineNumber OfEmployees Each airport has a unique AirportID and a name of the city (AirportCity) where it is located. Each city has (one, of course) City Population. A city can have more than one airport. . Each airport assigns certain number of gates (NumberOfGates Assigned) to the airlines that serve it. a) In the figure below, indicate functional dependencies by drawing lines with arrows. (10 points) AirportID AirportCity CityPopulation Airline Name AirlineNumberOf NumberOfGates Employees Assigned b) Normalize the relation AIRPORTS AND GATES to the second normal form (2NF). Show column names (underline primary keys) and functional dependencies. (10 points) c) Normalize the relation AIRPORTS AND GATES to the third normal form (3NF). Show table names, column names (underline primary keys), and functional dependencies. (10 points)