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

Business

Ismael Lowe

25 January, 15:02

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.

+2

Answers (2)

Know the Answer?

Cheeky · Answer 1

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.

Carleigh · Answer 2

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.