CHAPTER 7: QUESTIONS AND ANSWERS

• expression écrite

CHAPTER 7: QUESTIONS AND ANSWERS 1. What is an insertion anomaly? Ans: An insertion anomaly occurs when extra data beyond the desired data must be added to a table. 2. What is an update anomaly? Ans: An update anomaly occurs when it is necessary to change multiple rows to modify only a single fact. 3. What is a deletion anomaly? Ans: A deletion anomaly occurs whenever deleting a row inadvertently causes other data to be deleted.

• list fds
• many columns
• fds
• visitno visitdate patno patage patcity patzip provno provspecialty diagnosis v10020
• visitdate
• zipcode zipcode
• shipaddr
• itemno
• itemdesc
• nonkey column