The Third Normal Form has one more additional requirement

Third Normal Form (1NF)

     

Third Normal Form (1NF)

The Third Normal Form has one more additional requirement :

        A. It should meet all the requirements of the second normal form.

      B. It should remove columns that are not dependent upon the primary key.

In the Third Normal Form all columns depend upon the primary key. When one column depends upon the other column,  table break the rule and turns into the dependency on the primary key.      

Item	Colors
Pen	red
Pen	blue
Scale	red
Scale	yellow
Bag	blue
Bag	black

 

Item	Price	Tax
Pen	2.0	0.20
Scale	2.0	0.20
Bag	150.00	7.80

 

Tables are not in Second Normal Form because tax depends on price, not item.

Item	Colors
Pen	red
Pen	blue
Scale	red
Scale	yellow
Bag	blue
Bag	black

 

Item	Price
Pen	2.0
Scale	2.0
Bag	150.00

 

Price	Tax
2.0	0.20
150.00	7.80

Tables are now in Third Normal Form.

Related Tags for Third Normal Form (1NF):

More Tutorials from this section

• The Normal Forms
• Database Normalization
• Second Normal Form (2NF)
• Third Normal Form (1NF)
• Third Normal Form (1NF)
• Second Normal Form (2NF)
• The Normal Forms
• 1st 2nd & 3rd Normal Form
• Third Section
• dynamic form
• Normal Distribution java program?
• Flex third party development tools
• Data Normalization
• Pass values from form to form
• form
• Login form in jscript
• Plz help with third Question - Java Beginners
• How to ask a questions to you clearly with normal english?
• Difference between Normal Insert and BLOB insert
• Catching Normal Exceptions