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
E 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.
Ea Depict full key functional dependencies, partial functional dependencies if any and transitive functional dependencies if any in the AIRPORT RUNWAYS Table.
Eb Show the result of normalizing the AIRPORT RUNWAYS Table to NF and show the data from airport table
Ec Show the result of normalizing the AIRPORT RUNWAYS Table to NF and show the data from the airport table
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
