Forms Of Normalization

This is continuation of my previous post "What is Normalization"

http://blog-mstechnology.blogspot.com/2010/06/what-is-normalization.html

I hope following Brief Notes about Normalization will be helpful to you,

First Normal Form (1NF): 

·         No repeating group of data items

·         Each column should contain specific values

·         Each row is equivalent logical record

·         Relation should contains records of identical format

Second Normal Form (2NF):

·         Foreign Key Relation Ship

·         Each data items in a record is functionally dependent on the key of that record

·         Each record uniquely identified with the Key

·         No Redundant data

·         It should full fill the 1NF

Third Normal Form (3NF):

·         First Full fill second normal form

·         Example Fact Table

·         All non-key functionally dependent on primary key

Boyce-Codd Normal Form (BCNF):

·         Eliminate redundancy

·         It adheres both 2NF AND 3NF

Fourth Normal Form (4NF):

·         Eliminate multi dependency

Fifth Normal Form (5NF):

·         Eliminate cyclic dependency

Sixth Normal Form (6NF):

·         It satisfies No Non Trivial join at all,

·         Extending relational model, temporal dimensions

Domain Key Normal Form (DKNF):

·         No constraints other than domain constraints

What is Normalization?

• It is a process of efficiently organize the data in Database
• Normalization is Invented by Edgar Frank "Ted" Codd

Main goals of Normalization:

• Eliminate redundant Data
• Ensure Data Dependencies make sense

Advantages of Normalization:

• Reduce the Space consumption
• Ensure Data is logically stored

Types of Normal Forms:

• First Normal Form (1NF)
• Second Normal Form (2NF)
• Third Norm (3NF)
• Boyce-Codd Normal Form (BCNF)
• Forth Normal Form (4NF)
• Fifth Normal Form (5NF)
• Domain/Key Normal Form (DKNF)
• Sixth Normal Form (6NF)