Which anomaly occurs when deleting one record unintentionally removes other useful information?
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)
B.
Deletion anomaly
Detailed Explanation
- Deletion anomaly: Occurs when deleting a record also removes information that should have been retained.
- It is common in poorly designed and highly redundant tables.
- Normalization helps separate independent facts into appropriate relations.
OOps! You are currently offline.