Answer Happy

A city can have more than one airport. Each airport is located in one city and has one or more runways. Each runway has a RunwayNumber, which is unique within an airport (but not across all airports). The AIRPORT RUNWAYS Table captures the data about airports and runways. Each airport has a unique AirportID. • Each city has a unique AirportCity name and a CityPopulation. . . . . . . • Each runway has a RunwayLength and a RunwayWidth. Each runway was built by one contractor. Each contractor can build multiple runways and various airports. 1. Answer the following questions: A. Given the following table, depict the three most common functional dependencies. (6 points) B. Apply the normalization process to normalize the table (if needed). (9 points) Airport C. What can you say for the final table (s) and the description given for the movie aeters table? Give a short answer. (5 points) Each runway contractor has a unique RunwayContractorID and a unique Runway ContractorName. AIRPORT RUNWAYS TABLE AirportID Airport City City ORD ORD ORD ATL ATL MDW MDW Chicago, IL Chicago, IL Chicago, IL Atlanta, GA Atlanta, GA Chicago, IL Chicago, IL Population 2.7 million 2.7 million 2.7 million 1.2 million 1.2 million 2.7 million 2.7 million Runway Runway Runway Number ContractorID ContractorName Length 2500 m 3000 m 1 RC1 2 RC1 3 RC2 1 RC2 2 RC1 1 RC2 2 RC3 AirPavers AirPavers PerfectSurface PerfectSurface AirPavers PerfectSurface PermaSmooth Runway Runway Width 4000 m 3000 m 4000 m 2000 m 2000 m 40 m 50 m 50 m 45 m 50 m 35 m 30 m