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
Copyright ©2022 coderraj.com. All Rights Reserved.