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

Elvis Richards

14 July, 00:07

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?

Atkinson · 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.

Londyn Kramer · 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.