A normalization i s a process for evaluating and correcting table structure to minimize data redundancy.Where as denormalization is to get lower normal form. iwill be considring on this post 3 types of normalization only which are:
1NF
2NF
3NF
and the others are :
BCNF AND 4NF
second normal form is better than first normal form , and third normal form is better than second normal form.
So if you have bigger normal form it is better than less normal form.
i have created a table using Microsoft word , shows how to get 1NF, 2NF , 3NF:
Written by: Mohammed Alaslani
Advertisement
