For some relations, changing the data can have undesirable consequences called:
Answer: B
Correct answer: modification anomalies.
A poorly structured relation makes some changes impossible to perform cleanly: an insertion anomaly prevents a fact being recorded until some unrelated fact is known, a deletion anomaly destroys information as a side effect, and an update anomaly requires the same value to be changed in many places. Normalisation exists to remove them.
Please log in or register to report this question.