Redundancy can be a major problem in the design and operation of relational databases.If a database uses only one relation to store data,several problems may subsequently occur.The problem of changes (or updates)to data values being incorrectly recorded is known as
A)an update anomaly.
B)an insert anomaly.
C)a delete anomaly.
D)a memory anomaly.

Question

Quizplus · Accepted Answer

The problem of changes (or updates) to data values being incorrectly recorded is known as an update anomaly. This is a common issue in databases using only one relation to store data, as updates to one row can have unintended effects on other rows in the relation. The other choices (B, C, and D) are not directly related to the issue of redundant data and its impact on database integrity.

Redundancy Can Be a Major Problem in the Design and Operation