- Normalization is a database design technique that organizes table in a manner that reduces redundancy(useless) and dependency of data.
- Larage table dividing into smaller ones and defining relationships between them using foreign keys.
- To avoid insertion update and deletion anomaly.
Advantages of Normalization:
- Utilizing database or data redundancy using normalization.
- By normalizing, we may reduce null values.
- Data consistency within the database.
- Normalization allows for greater flexibility in database design.
- Easier Maintenance
- Improved Query Performance
Disadvantages of Normalization:
- It increases the complexity because no of table and relationship, which can make the data model harder to understand and manage.
- it decreases the query performance and speed in higher normal form (ex 4th and 5th).
- After Normalization it create complexity because after nomalization it create large no of table so it is hard to manage.
Database Normal Forms given below:
- 1NF (First Normal Form)
- 2NF (Second Normal Form)
- 3NF (Third Normal Form)
- BCNF (Boyce-Codd Normal Form)
- 4NF (Fourth Normal Form)
- 5NF (Fifth Normal Form)