Kai Keoni has created custom statues made out of scrap metal for over ten years.He lives above his shop in Martha's Vineyard,Maryland.Kai is an accounting fanatic and has kept detailed records of every statue he has ever created.For every sale,he obtains the customer's name and address,a description of the statue,and a picture of the statue sold to the customer.His unique style has recently attracted the attention of several celebrities.Ready to take his business to the next level,Kai has hired you to construct an accounting information system,which he wants modeled after his paper records.As you look over his records,you realize that sometimes the same customer is recorded by a slightly different name.For example,Mike Mulligan bought a horse statue,M.Mulligan bought a pig statue,and Mike M.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, which occurs when inconsistencies in the data arise because updates to one record are not propagated to all related records. In this case, the same customer is recorded under different names, which leads to an update anomaly because changes to one record may not be reflected in all related records. Entity integrity refers to the property that each row in a table represents a unique entity, referential integrity refers to the consistency between related tables, and insert anomaly occurs when a new record cannot be inserted into a table because it is missing required data. None of these apply to the problem described.

Kai Keoni Has Created Custom Statues Made Out of Scrap