Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

The list below tracks people and the books they check out from the local library. We sometimes need to delete a person by deleting the

image text in transcribed
The list below tracks people and the books they check out from the local library. We sometimes need to delete a person by deleting the row(s) containing that person. If we delete the person in row 3 (Long, Shelia), we also erroneously delete the data for the book named Legend. What is this term for this type of mistake? LastName FirstName Book Date Johnson James McBeath 1/1/2018 Smith David McBeath 12/14/2016 Long Shelia Legend 3/2/2017 Stevens Rachel 1984 3/1/2018 Franklin Frank 1984 2/13/2015 Smith David 10/11/2017 Longfellow Lance 12/2/2018 1984 Sunset City Sunset City Sunset City Stevens Rachel 3/13/2017 Johnson James 8/22/2017 deletion anomaly deletion variance deletion irregularity deletion inconsistency

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Database Processing

Authors: David Kroenke

11th Edition

0132302675, 9780132302678

More Books

Students also viewed these Databases questions

Question

76 Leadership concepts and applications.

Answered: 1 week ago