GeeCON Prague 2014*
The moose likes JDBC and the fly likes third normalization Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


JavaRanch » Java Forums » Databases » JDBC
Bookmark "third normalization" Watch "third normalization" New topic
Author

third normalization

Graham Thorpe
Ranch Hand

Joined: Mar 25, 2002
Posts: 265
Can any body explain what is mean by Third Normalization?
Adeel Ansari
Ranch Hand

Joined: Aug 15, 2004
Posts: 2874
Normalization is the process of removing redundant data from your tables in order to improve storage efficiency, data integrity and scalability. There are three basic forms of normalization. 1st, 2nd, and 3rd.

For more you can google with the words "3NF" or "Third Normailzation Form". You will get lot of results explaining this term.
Adeel Ansari
Ranch Hand

Joined: Aug 15, 2004
Posts: 2874
Well, I have got something simple and straight.

Third normal form (3NF) goes one large step further:
- Meet all the requirements of the second normal form.
- Remove columns that are not dependent upon the primary key.

cheers.
Scott Selikoff
author
Saloon Keeper

Joined: Oct 23, 2005
Posts: 3710
    
    5

I wrote an education tool for Database Normalization while working on my masters, feel free to try it out at:

DB Normalization Tool

Also, there's a specific section that defines the Normal Forms explicitly at:

Normal Forms

Hope it helps!


My Blog: Down Home Country Coding with Scott Selikoff
David O'Meara
Rancher

Joined: Mar 06, 2001
Posts: 13459

In my university days a friend told me: "The key, the whole key and nothing but the key".

1NF: The key
2NF: The whole key
3NF: Nothing but the key

It helped for me.
 
GeeCON Prague 2014
 
subject: third normalization