Redundancy Risks

Difficulty: Beginner

Question

Why is data redundancy bad in a relational database?

Answer

It leads to 'Update Anomalies' where you update a value in one place but forget to update the duplicate in another, leading to inconsistent state.

Concepts covered

Data Integrity