It's the process of organizing data in a relational database to reduce redundancy and improve data integrity.
Importance:
-
Minimize Redundancy: Eliminate duplicate data, reducing storage space.
-
Avoid Update Anomalies: Prevent inconsistencies when updating data.
-
Simplify Queries: Simplify data retrieval and improve query performance.
-
Enhance Data Integrity: Ensure accurate and consistent data.