What happens if a piece of data is stored in two places in the db?
Asked In:
BPSC TRE 3.0
Options
-
A.
Storage space is wasted and changing the data in one spot will cause data inconsistency
-
B.
Changing the data in one spot will cause data inconsistency
-
C.
Storage space is wasted
-
D.
More than one of the above
-
E.
None of the above
Correct Answer (Detailed Explanation is Below)
D.
More than one of the above
Detailed Explanation
- Data redundancy: Storing the same data in multiple places wastes storage space.
- Data inconsistency: If one copy is updated but another is not, different values may exist for the same information.
- Database normalization helps reduce unnecessary duplication and inconsistency.
