Which anomaly occurs when a new fact cannot be inserted into a table without adding unrelated 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)
A.
Insertion anomaly
Detailed Explanation
- Insertion anomaly: Occurs when a fact cannot be inserted independently because of the table structure.
- It may force users to enter unrelated or unavailable information.
- Proper normalization helps eliminate this problem.
OOps! You are currently offline.