Normalization is the process of organizing data in a database to reduce redundancy and improve data integrity. It involves decomposing tables into smaller, well-structured tables and defining relationships between them.
Benefits:
Eliminates Data Redundancy: Reduces storage space and inconsistencies
Prevents Update Anomalies: Changes need to be made in only one place
Improves Data Integrity: Reduces chances of inconsistent data
Easier Maintenance: Simpler to modify database structure
Drawbacks:
Increased complexity in queries (more JOINs)
Potential performance impact
More tables to manage
Rewriting in plainer words…
This answer doesn't lend itself to a diagram - it reads best . No credits were charged.
