Which of the following would not be found in a data dictionary entry for a data item? A) records containing a specific data item B) physical location of the data C) source of the data item D) field type 10) The update anomaly in non-normalized database tables A) occurs because of data redundancy. B) restricts addition of new fields or attributes. C) results in records that cannot be updated. D) is usually easily detected by users. 11) 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 some customers bought multiple statues at the same time. For example, Yasmeen Ghuari bought a Tin Man Status, a flying horseman statue, and a terrier statue. 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 12) In the database design approach known as normalization, the first assumption made about data is A) there is no redundancy in the data. B) the delete anomaly will not apply since all customer records will be maintained indefinitely. C) everything is initially stored in one large table. D) the data will not be maintained in 3NF tables. 19) Which one of the following results corresponds to the query below? A) Customer Name D. Ainge D. Ainge D. Ainge Date 10/15/2005 10/15/2005 10/28/2005 Customer Name SumOfQuantity DD. Ainge Page Break Quantity Customer Name D Ainge D. Ainge D. Ainge Date 10/15/2005 10/15/2005 10/28/2005 Description 2 Television 1 Microwave 2 Microw D) Quantity Customer Name D. Ainge D. Ainge D. Ainge Description 2 Television 1 Microwave 2 Microwave 20) Which one of the following results corresponds to the query below? A) Customer Name Sales Invoice # D. Ainge F. Roberts G. Kite B) Customer Name D. Ainge G. Kite F. Roberts Sales Invoice # 101 Salesperson J. Buck J. Buck J. Buck 105 104 D) Sales Invoice # 101 Customer Name D. Ainge F. Roberts G. Kite Salesperson J. Buck J. Buck J. Buck 105 104