Question: Que l: Consider the following relation with sample data: ABC Transport Project Table Project ID Project Name CountyID County Name ProjectManagerID Project Manager Name Project

 Que l: Consider the following relation with sample data: ABC Transport

Que l: Consider the following relation with sample data: ABC Transport Project Table Project ID Project Name CountyID County Name ProjectManagerID Project Manager Name Project Miles Within County 1 Road X 1 Wilson MI Bob 10.00 1 Road X 2 Ottawa MI Bob 17.00 1 Road X 3 Davis MI Bob 12.00 2 Road Y 3 Davis M2 Sue 23.00 3 Bridge A 1 Wilson M3 Lee 0.50 3 Bridge A 2 Ottawa M3 Lee 0.30 4 Tunnel 2 Ottawa MI Bob 2.00 S 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 ProjectMilesWithin 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

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!