ABC Transport Project Table Poletin Project Name County County Name Project Manager ID Project Manager Name ProjectMiles WithCounty 1 Road X 1 Wilson MI Bob 10.00 1 Rex 2 Onwa MI Bob 1 Read X 3 Davis MI Hab 12.00 Road Y 3 Davis M2 23.00 3 Bridge 1 Wilson 1 | M) Le Bridge ON M L 010 Tolo Mi Bob 2.00 5 Read w Peny M4 Bab 21.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