Saturday, May 10, 2008

DBMS Normalization Steps

Input RelationTransformationOutput relation
All relationsEliminate variable lenght records Remove multiattribute lines in Table1NF
1NF relationRemove dependency of non-key attribute on part of a multiattribute key2NF
2NFRemove dependency of non-key attributes on other non-key attributes3NF
3NFRemove dependency of an attribute of a multiattribute key on an attribute of another(overlapping)multiattribute keyBCNF
BCNFRemove more than one independent multivalued ependency from relation by splitting relation4NF
4NFAdd one relation relating attributes with multivalued dependeny to the two relatins with multivalued dependency5NF


Source:SMU

0 comments:

Post a Comment

Comments are moderated. No spam please.