The table below lists customer/car hire data. Each customer may hire cars from various outlets. A car is registered at a particular outlet and can be hired out to a customer on a given date. carReg make model custNo custName bireDate outletNo outletLoc M565 OGD Ford Escort C100 Smith, J 14/5/98 01 Bearsden M565 OGD Ford Escort C201 Hen, P 15/5/98 01 Bearsden N734 TPR Nissan Sunny C100 Smith, J 16/5/98 01 Bearsden M134 BRP Ford Escort C313 Blatt, O 14/5/98 02 Kelvinbridge M134 BRP Ford Escort C100 Smith, J 20/5/98 02 Kelvinbridge M611 OPQ Nissan Sunny C295 Pen, T 20/5/98 02 Kelvinbridge The table shown above is susceptible to update anomalies. Provide examples of how insertion, deletion, and modification anomalies could occur on this table.
The table below lists customer/car hire data. Each customer may hire cars from various outlets. A car is registered at a particular outlet and can be hired out to a customer on a given date. carReg make model custNo custName bireDate outletNo outletLoc M565 OGD Ford Escort C100 Smith, J 14/5/98 01 Bearsden M565 OGD Ford Escort C201 Hen, P 15/5/98 01 Bearsden N734 TPR Nissan Sunny C100 Smith, J 16/5/98 01 Bearsden M134 BRP Ford Escort C313 Blatt, O 14/5/98 02 Kelvinbridge M134 BRP Ford Escort C100 Smith, J 20/5/98 02 Kelvinbridge M611 OPQ Nissan Sunny C295 Pen, T 20/5/98 02 Kelvinbridge The table shown above is susceptible to update anomalies. Provide examples of how insertion, deletion, and modification anomalies could occur on this table.
Programming Logic & Design Comprehensive
9th Edition
ISBN:9781337669405
Author:FARRELL
Publisher:FARRELL
Chapter8: Advanced Data Handling Concepts
Section: Chapter Questions
Problem 17RQ
Related questions
Question
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 3 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
Programming Logic & Design Comprehensive
Computer Science
ISBN:
9781337669405
Author:
FARRELL
Publisher:
Cengage
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781305627482
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Np Ms Office 365/Excel 2016 I Ntermed
Computer Science
ISBN:
9781337508841
Author:
Carey
Publisher:
Cengage
Programming Logic & Design Comprehensive
Computer Science
ISBN:
9781337669405
Author:
FARRELL
Publisher:
Cengage
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781305627482
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Np Ms Office 365/Excel 2016 I Ntermed
Computer Science
ISBN:
9781337508841
Author:
Carey
Publisher:
Cengage