Suppose That You Need to Update One Value of the Column

question 84

Multiple Choice

Suppose that you need to update one value of the column SalesCost in a relation.The way the relation is constructed,this value actually needs to be changed in three different rows.However,you only change the value in two of the rows.You have just created an a(n) ________.

• A)normalization anomaly
• B)insertion anomaly
• C)update anomaly
• D)deletion anomaly
• E)removal anomaly