Suppose That You Need to Update One Value of the Column

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 a(n) ________.

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