GeekInterview.com
   Home |  Tech FAQ  |   Interview Questions |  Placement Papers |  Tech Articles |  Learn |  Freelance Projects |  Online Testing |  Geeks Talk |  Job Postings |  Knowledge Base | Site Search |  Add/Ask Question

GeekInterview.com  >  Interview Questions  >  Concepts  >  Data Modeling
Go To First  |  Previous Question  |  Next Question 
 Data Modeling  |  Question 3 of 21    Print  
Describe the third normal form?

  
Total Answers and Comments: 6 Last Update: May 11, 2008   
  
 Sponsored Links



 
 Best Rated Answer

No best answer available. Please pick the good answer available or submit your answer.
June 20, 2005 15:15:31   #1  
mdr.mohan rao        

RE: Describe the third normal form?
A table is said to be 3nf if it is already in 2nf and every non-key column is non transitively dependent on primary key.
 
Is this answer useful? Yes | No
June 24, 2005 20:28:17   #2  
Kevin B        

RE: Describe the third normal form?
An entity is in the third normal form if it is in the second normal form and all of its attributes are not transitively dependent on the primary key. Transitive dependence means that descriptor key attributes depend not only on the whole primary key, but also on other descriptor key attributes that, in turn, depend on the primary key. In SQL terms, the third normal form means that no column within a table is dependent on a descriptor column that, in turn, depends on the primary key. 
 
 
 
For 3NF, first, the table must be in 2NF, plus, we want to make sure that the non-key fields are dependent upon ONLY the PK, and not other non-key fields for its existence. This is very similar to to 2NF, except that now you are comparing the non-key fields to OTHER non-key fields. After all, we know that the relationship to the PK is good, because we established that in 2NF. 
 

 
Is this answer useful? Yes | No
August 23, 2005 17:49:07   #3  
Sriharsha Hanumanth        

RE: Describe the third normal form?
An unnormalized relation is in 1NF If it does not contain any repeating groups. 
A 1NF relation is in 2NF if it does not contain any partial dependencies. 
A 2NF relation is in 3NF if every determinant is a candidate key.

 
Is this answer useful? Yes | No
June 24, 2006 08:36:25   #4  
       

RE: Describe the third normal form
eliminate fields that do not depend on the primary key.
 
Is this answer useful? Yes | No
June 15, 2007 15:34:49   #5  
Sujatars Member Since: December 2006   Contribution: 217    

RE: Describe the third normal form?
Remove columns that are not dependent upon the primary key
 
Is this answer useful? Yes | No
May 11, 2008 23:32:22   #6  
vas_kal Member Since: May 2008   Contribution: 1    

RE: Describe the third normal form?
3NF allows transitive dependency

 
Is this answer useful? Yes | No


 
Go To Top


 Sponsored Links



 
Sponsored Links

 
Sponsored Links

 




About Us  |   Privacy Policy  |   Terms and Conditions  |   Contact  |   Site Map  |   Add Question  |   Propose Category  |   RSS Feeds  |   Articles Sitemap  |   Site Updates  |   Add Resource

Copyright © 2005 - 2008 GeekInterview.com. All Rights Reserved
Page copy protected against web site content infringement by Copyscape