the following relation with sample data. ns, Update Anomalies, and Normalization 121 ent of AIRPORT KLX TABLE AirlinelD AirlineName TerminalID NumberOfGates NumberOfDepartingFlights 11-Dec UA 11-DecNW 11-Dec AA 11-Dec DL 11-Dec JB 12-Dec UA 12-Dec DL Delta United Northwest A 20 20 20 15 34 Delta 8 et Blue United 20 15 15 20 6 29 20 12-Dec SWA Southwest C The AIRPORT KLX Table captures the data about dailu departing flights at the KLX Airport. ID and an Airline Name. E4.5b Using the AIRPORT KLX Table, describe an ex- ample that illustrates the deletion anomaly E4.5c Using the AIRPORT KLX Table, describe an ex- . Each airline operating at KLX airport has a unique Airline . Each terminal at KLX airport has a unique Terminal ID ample that illustrates the modification anomaly E4.5d Depict full key functional dependencies, partial and a fixed Number of Gates. functional dependencies (if any), and transitive func- tional dependencies (if any) in the AIRPORT KLX Table. . Each airline is permanently assigned to one (and only one) terminal at the KLX Airport . Each terminal at KLX Airport can have multiple airlines E4.5e Show the result of normalizing the AIRPORT KLX E4.5f Show the result of normalizing the AIRPORT KLX assigned to it. Departing Flights at KLX Airport for each airline. 4.5a Using the AIRPORT KLX Table, describe an ex- Table to 2NF . Each day (Date), this table records the Number of Table to 3NF. E4.5g Using the set of tables resulting from E4.5f, ample that illustrates the insertion anomaly. describe how the anomalies shown in E4.5a, E4.5b, and E4.5c are eliminated