File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
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
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
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: 3740
    
  10

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
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.
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: third normalization