Which type of anomaly occurs when the same information must be modified in multiple records?
Options
-
A.
Insertion anomaly
-
B.
Deletion anomaly
-
C.
Update anomaly
-
D.
More than one of the above
-
E.
None of the above
Correct Answer (Detailed Explanation is Below)
C.
Update anomaly
Detailed Explanation
- Update anomaly: Occurs when duplicated information must be changed in multiple records.
- If some copies are not updated, inconsistent data may result.
- Normalization reduces this problem by organizing data into related tables.
OOps! You are currently offline.