jQuery in Action, 3rd edition
The moose likes JDBC and Relational Databases and the fly likes when  to use  third  normal  form  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 "when  to use  third  normal  form  " Watch "when  to use  third  normal  form  " New topic

when to use third normal form

rehans oberoi
Ranch Hand

Joined: Dec 06, 2005
Posts: 174

i can say , when there is relationship between non key attribute.
we have to made seprate table for that.

third normal form says . all the non key attribute must be dependent
only on the primary key.

please correct me
Jeanne Boyarsky
author & internet detective

Joined: May 26, 2003
Posts: 32614

Is it a one to one relationship or a correlation? If one non-key field is always the same value given the value of another non-key field, you need a separate table. If it is a correlation (like it is usually a certain value), that is fine.

[OCA 8 book] [Blog] [JavaRanch FAQ] [How To Ask Questions The Smart Way] [Book Promos]
Other Certs: SCEA Part 1, Part 2 & 3, Core Spring 3, TOGAF part 1 and part 2
I agree. Here's the link: http://aspose.com/file-tools
subject: when to use third normal form
It's not a secret anymore!