Normalization
- Normalization is the process of organizing the data in the database.
- It is used to remove or minimize the redundancy from a relation
- Keep in mind, while minimizing the redundancy, that functional dependency rules don’t violated.
Normalization use different types of normal forms to reduce redundancy from the database table.
Types of Normal Forms
There are the four types of normal forms
| Normal Form | Description |
| 1NF | A relation will be in 1NF if it contains an atomic value. |
| 2NF | A relation will be in 2NF if it follow the followings
• It is in 1NF |
| 3NF | A relation will be in 3NF if it follow the followings
• It is in 2NF |
| BCNF | A relation will be in BCNF if it follow the followings
|
| 4NF | A relation will be in 4NF if it follow the followings • It is in Boyce Codd normal form • It has no multi-valued dependency. |
| 5NF | A relation is in 5NF if it follow the followings • It is in 4NF • It does not contain any join dependency and joining should be lossless. |