File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes JDBC and Relational Databases and the fly likes third normalization Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of Java Interview Guide this week in the Jobs Discussion forum!
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "third normalization" Watch "third normalization" New topic

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.

Scott Selikoff
Saloon Keeper

Joined: Oct 23, 2005
Posts: 3753

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!

[OCA 8 Book] [Blog]
David O'Meara

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.
I agree. Here's the link:
subject: third normalization
It's not a secret anymore!