E4.6 Consider the following relation with sample data. DEPARTMENT OF TRANSPORTATION (DOT) PROJECT TABLE ProjectID ProjectName CountyID CountyName ProjectManagerID ProjectManagerName ProjectMilesWithinCounty 1 Road X 1 Wilson M1 Bob 10.00 1 Road X 2 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 4 Tunnel Q 2 Ottawa M1 Bob 2.00 5 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. . А project mапager can maпage 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.6 Consider the following relation with sample data. DEPARTMENT OF TRANSPORTATION (DOT) PROJECT TABLE ProjectID ProjectName CountyID CountyName ProjectManagerID ProjectManagerName ProjectMilesWithinCounty 1 Road X 1 Wilson M1 Bob 10.00 1 Road X 2 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 4 Tunnel Q 2 Ottawa M1 Bob 2.00 5 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. . А project mапager can maпage 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.
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
Related questions
Question
question is attached
Transcribed Image Text:E4.6 Consider the following relation with sample data.
DEPARTMENT OF TRANSPORTATION (DOT) PROJECT TABLE
ProjectID
ProjectName
CountyID
CountyName
ProjectManagerID
ProjectManagerName
ProjectMilesWithinCounty
1
Road X
1
Wilson
M1
Bob
10.00
1
Road X
2
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
4
Tunnel Q
2
Ottawa
M1
Bob
2.00
5
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.
. А project mапager can maпage 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.
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution!
Trending now
This is a popular solution!
Step by step
Solved in 4 steps
Knowledge Booster
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
Computer Science
ISBN:
9780078022159
Author:
Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:
McGraw-Hill Education
Starting Out with Python (4th Edition)
Computer Science
ISBN:
9780134444321
Author:
Tony Gaddis
Publisher:
PEARSON
Digital Fundamentals (11th Edition)
Computer Science
ISBN:
9780132737968
Author:
Thomas L. Floyd
Publisher:
PEARSON
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)
Computer Science
ISBN:
9780134444321
Author:
Tony Gaddis
Publisher:
PEARSON
Digital Fundamentals (11th Edition)
Computer Science
ISBN:
9780132737968
Author:
Thomas L. Floyd
Publisher:
PEARSON
C How to Program (8th Edition)
Computer Science
ISBN:
9780133976892
Author:
Paul J. Deitel, Harvey Deitel
Publisher:
PEARSON
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781337627900
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Programmable Logic Controllers
Computer Science
ISBN:
9780073373843
Author:
Frank D. Petruzella
Publisher:
McGraw-Hill Education