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
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-