219k views
3 votes
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 votes

Answer:

Update

Step-by-step 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.

User Hernan Arber
by
4.5k points
6 votes

Answer:

update anomaly

Step-by-step 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.

User George Huang
by
4.1k points