What is normalization and types of normalization in MySql

Normalization is a process of analysis a given relation with the help of key and functional dependency to archive desirable properties.

To decompose a bigger relation into smaller relations so that it can satisfy the desirable property.

Desirable property of a good design-

A)-Less NULL value

B)-Lesser redundancy

C)-Avoid data anomolies(Insert,Delete,Update)

Relational model every column should take automic value.

Higher the normal form better is design.

Different nornal form-

1)-1NF

2)-2NF

3)-3NF

4)-BCNF

5)-4NF

6)-5NF