Ex 4.5 a, b, c, d, e, f, g

Chapter 4. Update Operations, Update anomalies, and Normalization 1 2 relation sample . Consider the following with data IA AIRPORT KLX TABLE bate Airlinelo AirlineName terminalo NumberoiGates NumberOIDeparting flights United Dec JUA A 20 De NW Northwest A 20 | American A 200 Dee DL JDoha BD 20 1 Dea BJet Blue DISCO 2 Dec UA United A2020 12Dec DL Data B1820 12-Dec SWA Southwest C167 11- 11-Dec IAA The AIRPORT KLX Table captures the data about daily darting flights at the KLX Airport. . Each airline operating at KLX airport has a unique Airline ID and an Airline Name . Each terminal at KLX airport has a unique Terminal ID and a fixed Number of Gates. Each airline is permanently assigned to one (and only one) terminal at the KLX Airport. Each terminal at KLX Airport an are multiple airlines assigned to it. Each day (Dale), this table records the Number of Departing Flights at KLX Airport for each airline. E4.5b Using the AIRPORT KLX Table, describe an ex ample that illustrates the deletion anomaly. B.Sc Using the AIRPORT KLX Table, describe an ex ample that lustrates the modification anoma E.5d Depict full key functional dependencies, partial functional dependencies (if any), and transitive fune tional dependencies if anyin the AIRPORT KLX Table EAL5e Show the result of normalizing the AIRPORT KILX Table to 2NE E4.5 Show the result of normalizing the AIRPORT KLX Table to IN E4.5g Using the set of tables resulting from E4.5f, describe how the anomalies shown in E4.5 a E.5b, and E.5c are eliminated E.5a Using the AIRPORT KLX Table, describe an ex ample that illustrates the insertion anomaly. E.6 Consider the following relation with sample data. DEPARTMENT OF TRANSPORTATON DoT PROJECT TABLE Projectio ProjectName County CountyName ProjectManagerld ProjectManagerName ProjectMiles within County Road XI Wilson MI Bob .00 Road X12 Tunnel O2 Ottawa Road W length (in miles). The DEPARTMENT OF TRANSPORTATION (DO Project Table captures the data about projects and their Each project has Name a unique Project ID and Project . County has a unique County ID and County Name a project manager has a unique Project Manager ID and Each project has one project manager A project manager can manage serveral projects. A project can spun across storal counties. This table records the length of the project in a county in the ProjectMiles WithinCounty alumn. fame