ABC Transport Project Table ProjectID Project Name CountyID County Name Project Manager ID Project Manager Name Project Miles WithinCounty 1 Road X 1 Wilson MI Bob 10.00 1 Road X 2 Ottawa M1 Bob 17.00 1 Road X 3 Davis MI Bob 12.00 Road Y 3 Davis M2 Sue 23.00 3 Bridge A 1 Wilson M3 Lee 0.30 3 Bridge A 2 Ottawa M3 Lee 0.30 4 Tunnel 2 Ottawa MI Bob 2.00 5 Road w 4 Pony M4 Bob 23.00 . . The ABC Transport's Project Table captures the data about projects and their length (in miles). Each project has a unique Project ID and Project Name. Each county has a unique County ID and County Name. Each project manager has a unique Project Manager ID and Project Manager Name. Each project has one project manager. A project manager can manage several projects. A project can span across several counties. This table records the length of the project in a county in the Project Miles Within County column. A. Using the Project Table, describe an example that illustrates the insertion anomaly. B. Using the Project Table, describe an example that illustrates the deletion anomaly. C. Using the Project 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 Project Table. E. Show the result of normalizing the Runways Table to 2NF. F. Show the result of normalizing the Runways Table to 3NF