a. Using the AIRPORT KLX Table, describe an example that illustrates the insertion anomaly. b. Using the

Question:

a. Using the AIRPORT KLX Table, describe an example that illustrates the insertion anomaly.
b. Using the AIRPORT KLX Table, describe an example that illustrates the deletion anomaly.
c. Using the AIRPORT KLX Table, describe an example that illustrates the modification anomaly.
d. Depict full key functional dependencies, partial functional dependencies (if any), and transitive functional dependencies (if any) in the AIRPORT KLX Table.
e. Show the result of normalizing the AIRPORT KLX Table to 2NF.
f. Show the result of normalizing the AIRPORT KLX Table to 3NF.
g. Using the set of tables resulting from E4.5f, describe how the anomalies shown in E4.5a, E4.5b, and E4.5c are eliminated.