aspose file tools*
The moose likes JDBC 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
Bookmark "when  to use  third  normal  form  " Watch "when  to use  third  normal  form  " New topic
Author

when to use third normal form

rehans oberoi
Ranch Hand

Joined: Dec 06, 2005
Posts: 174
hi


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
internet detective
Marshal

Joined: May 26, 2003
Posts: 30299
    
150

Rehans,
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.


[Blog] [JavaRanch FAQ] [How To Ask Questions The Smart Way] [Book Promos]
Blogging on Certs: SCEA Part 1, Part 2 & 3, Core Spring 3, OCAJP, OCPJP beta, TOGAF part 1 and part 2
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: when to use third normal form