Scuz Bootes 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 handwritten 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 the
A) entity integrity rule.
B) referential integrity rule.
C) update anomaly.
D) insert anomaly.

Question

Quizplus · Accepted Answer

The entity integrity rule states that each entity (in this case, each customer) must have a unique identifier. In this case, Scuz needs to assign a unique customer number to each customer to prevent confusion between records and ensure accuracy in the AIS. The referential integrity rule ensures that relationships between entities are maintained, while update and insert anomalies refer to issues that can arise when adding or editing data in a database, which are not relevant to this scenario.

Scuz Bootes Has Been Doing Custom Choppers,piercings,and Tattoos for Over