Question

Abby Burke has created custom statues made out of scrap metal for over ten years. Abby has kept detailed records of every statue she has ever created. For every sale, she obtains the customer's name and address, a description of the statue, and a picture of the statue sold to the customer. Her unique style has recently attracted the attention of several celebrities. Ready to take her business to the next level, Abby has hired you to construct an accounting information system, which she wants modeled after her paper records. As you look over her 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 bear statue, and Mike M. all seem tobe the same person. This is an example of what type of problem in the existing records?A) entity integrityB) referential integrityC) update anomalyD) insert anomaly

Answer 1

Answer:The correct option is C. Update Anomaly.

Explanation: An update anomaly is a kind of data anomaly, it is the phenomenon in which a data inconsistency results from data redundancy and a partial update.

Case in point, the situation whereby each employee in an organization is associated with a department and also the student group they participate in.

Another example can be seen in the scenario presented above, whereby there seems to be an error of associating one person who bears the name of Mike Mulligan to different purchases at different points in time.