Computer Science
Database Normalization
Understand the purpose of database normalization.
Normalization = Organizing Relations to Reduce Redundancy and Anomalies
Formula Explanation
Normalization structures relational tables and dependencies to reduce undesirable duplication and update anomalies.
Variables Explained
Redundancy = Unnecessary repeated data; Anomalies = Insert, update or delete problems.
Solved Example
What is the primary goal of normalization?
To reduce redundancy and prevent data anomalies.