Sunday 21 October 2012

Continuation of Normalization Forms

Fourth Normal Form (4NF):-

(i)    Remove the multi-valued  dependency.
(ii)    Make separate table for multi-valued  Fields.


Result:-

 
Fifth Normal Form (5NF):- 

(i)    Remove the join dependencies.
(ii)    Break the database table into smaller and smaller tables to remove all data redundancy.



Result:-


0 comments:

Post a Comment