File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

third normalization

 
Graham Thorpe
Ranch Hand
Posts: 265
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Can any body explain what is mean by Third Normalization?
 
Adeel Ansari
Ranch Hand
Posts: 2874
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 2874
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 3901
16
Eclipse IDE Flex Google Web Toolkit
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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!
 
David O'Meara
Rancher
Posts: 13459
Android Eclipse IDE Ubuntu
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic