Question: E 4 . 1 3 Consider the following relation with sample data. AIRPORT RUNWAYS TABLE The AIRPORT RUNWAYS Table captures the data about airports and

E4.13 Consider the following relation with sample data.
AIRPORT RUNWAYS TABLE
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.
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).
Each runway has a RunwayLength and a RunwayWidth.
Each runway was built by one contractor.
Each contractor can build multiple runways and various airports.
Each runway contractor has a unique RunwayContractorID and a unique RunwayContractorName.
E4.13a Depict full key functional dependencies, partial functional dependencies (if any), and transitive functional dependencies (if any) in the AIRPORT RUNWAYS Table.
E4.13b Show the result of normalizing the AIRPORT RUNWAYS Table to 2NF and show the data from airport table
E4.13c Show the result of normalizing the AIRPORT RUNWAYS Table to 3NF and show the data from the airport table
E 4 . 1 3 Consider the following relation with

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Programming Questions!