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 notice that some customer last names have different first names in different records.For example,R.Framington Farnsworth,Bob Farnsworth,and Sam Farnsworth all seem to be the same person.You explain to Abby 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 a database must have a unique identifier. In this case, each customer should have a unique customer number to avoid confusion and ensure accuracy. The referential integrity rule is not relevant as Abby does not have any relationships between tables in her system. Update and insert anomalies refer to problems that occur during data manipulation and are not relevant to this situation.

Abby Burke Has Created Custom Statues Made Out of Scrap