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.You explain to Scuz that every customer must be identified by a unique customer number in the AIS.You are referring to:
A)Entity integrity
B)Referential integrity
C)An update anomaly
D)An insert anomaly

Question

Quizplus · Accepted Answer

Entity integrity ensures that each record in a database is uniquely identified by a primary key, in this case, a unique customer number. This eliminates the problem of duplicate or inconsistent data, such as different first names for the same customer in different records. Referential integrity ensures that relationships between tables are maintained, but it is not directly related to the issue of duplicate data. Insert and update anomalies are issues that arise when there are inconsistencies or errors in a database structure or design, but do not necessarily relate to the specific issue of identifying unique customers.

Scuz Bootes Is a Sexagenarian Who Has Been Doing Custom