Pintu Kumar Singh

• Nov 3rd, 2005

 

Third Normal Form (3NF): No duplicate information is permitted. So, for example, if two tables both require a common field, this common field information should be separated into a different table.

Abhishek Mukherjee

• May 5th, 2006

 

A relation is in 3 NF if it is in 2 NF and no NONKEY(Not Primary Key) attribute is functionally dependent on any other NONKEY attribute.

thumatinagaraju

 Profile Answers by thumatinagaraju Questions by thumatinagaraju

• Oct 23rd, 2006

 

in 3rd normal form every non-key column must be refereed by the primary key column .. this is the third normal form.

abhishek mittal

• Dec 23rd, 2006

 

3rd level of normalization is basically to remove the redundancy of data & to preserve the functional dependencies.for a relation with set of FDs 'F' ,its in 3rd NF wrt closure of F if satisfies anyone of the following 3 conditions:-

1) A -> B should be the trivial FD.

2) for any FD A -> B, A should be the super key of relation.

3)??for any FD A -> B, (B-A) should be contained in the candidate key of relation.