Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Consider the following relation with sample data DEPARTMENT OF TRANSPORTATION (DOT) PROJECT TABLE ProjectiD ProjectName CountylD CountyName ProjectManagerlD Road X Road X Road X Road
Consider the following relation with sample data DEPARTMENT OF TRANSPORTATION (DOT) PROJECT TABLE ProjectiD ProjectName CountylD CountyName ProjectManagerlD Road X Road X Road X Road Y Bridge A 1 Bridge A 2 Tunnel O ProjectManagerName ProjectMilesWithinCounty Bob Bob Bob Sue Wilson Ottawa Davis M1 M1 M1 M2 M3 M3 M1 M4 10.00 17.00 12.00 23.00 0.50 0.30 2.00 23.00 3 3 Wilson Ottawa Ottawa Lee Bob Bob 5 Road W The DEPARTMENT OF TRANSPORTATION (DOT) Project Table captures the data about projects and their . Each project has one project manager . A project manager can manage several projects. e A project can span across several counties. . This table records the length of the project in a county in 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 the ProjectMilesWithinCounty colunn. Project Manager Name Question a: Using the above DOT Project Table, describe an example that illustrates the insertion anaomoly Question b: : Using the above DOT Project Table, describe an example that illustrates the deletion anaomoly Question c:: Using the above DOT Project Table, describe an example that illustrates the modification anaomoly Question d: Depict full key dependecies, partial function dependencies (if any), and transative functional dependencies (if any) in the DOT Project Table. Question e: Show the result of normalizing the DOT Project Table to 2NF Question f: Show the result of normalixing the DOT Project Table to 3NF
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started