Scuz Bootes is a sexagenarian who has been doing custom choppers,piercings,and tattoos for over thirty years.His home and place of business is a garage in the harbor district of Seattle,Washington.He has meticulous records of every job he has ever done,carefully hand written with the customer name and address,a description of the job,and an attached picture of the bike or body part before and after customization.His unique style has recently attracted the attention of national media after several celebrities sought him out and showcased his work.Business is booming.Consequently,Scuz has hired you to construct an accounting information system,beginning with the historical records.As you read through the records,you notice that some customer last names have different first names in different records.For example,R.Framington Farnsworth (custom chopper),Bob Farnsworth (tattoo),and Snake Farnsworth (tattoos and piercings)all seem to be the same person.This is an example of what type of problem in the existing records?
A)Entity integrity
B)Referential integrity
C)Update anomaly
D)Insert anomaly

Question

Quizplus · Accepted Answer

This is an example of an update anomaly. An update anomaly is when data is duplicated and inconsistent information exists within the same database. In this case, the same customer is listed under different names in different records, causing inconsistency and confusion.

Scuz Bootes Is a Sexagenarian Who Has Been Doing Custom