Homework Help is Here – Start Your Trial Now!
Engineering
Computer Science
the whole question is attached as a picture  Answer only the below question  E4.6g Using the set of tables resulting from E4.6f, describe how the anomalies shown in E4.6a, E4.6b, and E4.6c are eliminated.

the whole question is attached as a picture  Answer only the below question  E4.6g Using the set of tables resulting from E4.6f, describe how the anomalies shown in E4.6a, E4.6b, and E4.6c are eliminated.

Database System Concepts
Database System Concepts
7th Edition
ISBN:9780078022159
Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Chapter1: Introduction
Section: Chapter Questions
Problem 1PE
See similar textbooks
icon
Related questions
Question

the whole question is attached as a picture 

Answer only the below question 

E4.6g Using the set of tables resulting from E4.6f, describe how the anomalies shown in E4.6a, E4.6b, and E4.6c are eliminated.

E4.6 Consider the following relation with sample data. DEPARTMENT OF TRANSPORTATION (DOT) PROJECT TABLE ProjectID ProjectName CountyID CountyName ProjectManagerID ProjectManagerName ProjectMiles WithinCounty Road X 1 Wilson M1 Bob 10.00 1 Road X Ottawa M1 Bob 17.00 1 Road X 3 Davis M1 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 Tunnel Q Ottawa M1 Bob 2.00 Road W 4 Pony М4 Bob 23.00 • The DEPARTMENT OF TRANSPORTATION (DOT) 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 ProjectMilesWithinCounty column. E4.6a Using the DOT PROJECT Table, describe an example that illustrates the insertion anomaly. E4.6b Using the DOT PROJECT Table, describe an example that illustrates the deletion anomaly. E4.6c Using the DOT PROJECT Table, describe an example that illustrates the modification anomaly. E4.6d Depict full key functional dependencies, partial functional dependencies (if any), and transitive functional dependencies (if any) in the DOT PROJECT Table. E4.6e Show the result of normalizing the DOT PROJECT Table to 2NF. E4.6f Show the result of normalizing the DOT PROJECT Table to 3NF. E4.6g Using the set of tables resulting from E4.6f, describe how the anomalies shown in E4.6a, E4.6b, and E4.6c are eliminated. st
Transcribed Image Text:E4.6 Consider the following relation with sample data. DEPARTMENT OF TRANSPORTATION (DOT) PROJECT TABLE ProjectID ProjectName CountyID CountyName ProjectManagerID ProjectManagerName ProjectMiles WithinCounty Road X 1 Wilson M1 Bob 10.00 1 Road X Ottawa M1 Bob 17.00 1 Road X 3 Davis M1 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 Tunnel Q Ottawa M1 Bob 2.00 Road W 4 Pony М4 Bob 23.00 • The DEPARTMENT OF TRANSPORTATION (DOT) 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 ProjectMilesWithinCounty column. E4.6a Using the DOT PROJECT Table, describe an example that illustrates the insertion anomaly. E4.6b Using the DOT PROJECT Table, describe an example that illustrates the deletion anomaly. E4.6c Using the DOT PROJECT Table, describe an example that illustrates the modification anomaly. E4.6d Depict full key functional dependencies, partial functional dependencies (if any), and transitive functional dependencies (if any) in the DOT PROJECT Table. E4.6e Show the result of normalizing the DOT PROJECT Table to 2NF. E4.6f Show the result of normalizing the DOT PROJECT Table to 3NF. E4.6g Using the set of tables resulting from E4.6f, describe how the anomalies shown in E4.6a, E4.6b, and E4.6c are eliminated. st
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps

SEE SOLUTIONCheck out a sample Q&A here
Blurred answer
Knowledge Booster
Stack
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.
Recommended textbooks for you
Database System Concepts
Database System Concepts
Computer Science
ISBN:
9780078022159
Author:
Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:
McGraw-Hill Education
Starting Out with Python (4th Edition)
Starting Out with Python (4th Edition)
Computer Science
ISBN:
9780134444321
Author:
Tony Gaddis
Publisher:
PEARSON
Digital Fundamentals (11th Edition)
Digital Fundamentals (11th Edition)
Computer Science
ISBN:
9780132737968
Author:
Thomas L. Floyd
Publisher:
PEARSON
C How to Program (8th Edition)
C How to Program (8th Edition)
Computer Science
ISBN:
9780133976892
Author:
Paul J. Deitel, Harvey Deitel
Publisher:
PEARSON
Database Systems: Design, Implementation, & Manag…
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781337627900
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Programmable Logic Controllers
Programmable Logic Controllers
Computer Science
ISBN:
9780073373843
Author:
Frank D. Petruzella
Publisher:
McGraw-Hill Education
SEE MORE TEXTBOOKS