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



Popular posts from this blog

Adobe Stand Alone Flash Player for Linux

Essential adb Command Examples

[Solved] invalid partition table on /dev/sda -- wrong signature 0.