Question: Que 2: Consider the following relation with sample data. Airport Runways Table: City Airport Airport City Population Runway Number Runway ContractorID Runway Contractor Name Runway

Que 2: Consider the following relation with sample data. Airport Runways Table: City Airport Airport City Population Runway Number Runway ContractorID Runway Contractor Name Runway Length Runway Width ORD Chicago, IL 2.7 million RCI Air Pavers 2.500 m 40 m ORD Chicago, IL 2.7 million 2 RCI Air Pavers 3.000 m ORD Chicago, IL 2.7 million 3 RC2 4.000 in 30 m Perfect Surface Perfect Surface ATL Atlanta, GA 1.2 million ! RC2 3.000 m ATL Atlanta, GA 1.2 million 2 RCI AirPavers 4.000 m Som LAX Los Angeles CA 4.0 million ! RCI Air Pavers 2.500 m 40 m LAX 4.0 million 2 RC2 Los Angeles. CA PerfectSurface 3.000 m 40 m MDW Chicago, IL 2.7 million 1 RC2 Perfect Surface 2.000 m 35 m MDW Chicago, IL 2.7 million 2 RC PermaSmooth 2.000 m 30 m . An 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 City Population 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 Runway Number which is unique within an airport (but not across all airports). Each runway has a Rumus Length and a Rumaullidth Each runway was built by one contractor. Each contractor can build multiple runways and various airports. Each runway contractor has a unique Ruroua ContractorID and a unique Rumxa Contractor Name. A. Depict full key functional dependencies, partial functional dependencies (if any), and transitive functional dependencies (if any) in the Runways Table. B. Show the result of normalizing the Runways Table to 2NF. C. Show the result of normalizing the Runways Table to 3NF
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
