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) ___ anomaly.

Question

Dominique Choi

Business

5 August, 13:32

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) ___ anomaly.

+3

Answers (2)

Know the Answer?

Yusuf Rollins · Answer 1

update anomaly

Explanation:

Based on the information provided within the question it can be said that in this scenario it seems that you have just created an update anomaly. This term refers to a inconsistency in the data that was created due to data redundancy or the input of a partial update in the document. Which is what you have done by not updated all three of the columns that required the update.

Puddles · Answer 2

Update

Explanation:

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) update anomaly.