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

Question

Quizplus · Accepted Answer

An update anomaly occurs when changing data in a relation leads to inconsistencies or errors in the relation. In this case, updating one value in the SalesCost column should affect three different rows, but if the update only happens in two of the rows, there is an inconsistency in the data. This is an example of an update anomaly.

Suppose That You Need to Update One Value of the Column