Subject: Relational Database

Using the AIRPORT KLX TABLE, describe an example that illustrates the Deletion anomaly:

Using the AIRPORT KLX TABLE, describe an example that illustrates the Insertion anomaly:

Using the AIRPORT KLX TABLE, describe an example that illustrates the Update anomaly:

Given the AIRPORT KLX TABLE, please identify all the full key functional dependencies that are present, partial functional dependencies (if any), and transitive functional dependencies (if any):

Show the result of normalizing the AIRPORT KLX TABLE to 2NF:

Show the result of normalizing the AIRPORT KLX TABLE to 3NF:

AIRPORT KLX TABLE Date ilinelD AirlineName TerminallD NumberOfGates NumberOfDepartingFlights 11-Dec UA 11-DecNW 11-DecAA 11-DecDL 11-Dec JB 12-Dec UA 12-Dec DL 12-DecSWA SouthwestC United Northwest A American Delta Jet Blue United Delta 20 20 20 15 15 20 15 15 34 17 20 6 29 20