Scuz Bootes Is a Sexagenarian Who Has Been Doing Custom

question 89

Multiple Choice

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 describe multiple services.For example,Sheila Yasgur (notation: won lottery) got a custom chopper,multiple tattoos,and piercings in undiscloed locations (no pictures.) You realize that,in these cases,a single written record will have to be translated into multiple sales records.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

---

Definitions:

Primary Key

A unique identifier for each record in a database table, ensuring no two rows have the same key.

Employee Table

A structured arrangement of data often in rows and columns that pertains to employees.

Social Security Number

A nine-digit number issued to U.S. citizens, permanent residents, and temporary working residents that tracks individuals for Social Security and tax purposes.

Data Type

A classification identifying one of various types of data, such as integer, floating-point, string, etc., that determines the possible values for that type, as well as the operations that can be performed on it.