Technical - What is 3rd level of normalization ?

GeekInterview.com > Placement Papers > HP (Hewlett-Packard) > Technical

Go To First | Previous Question | Next Question

Technical | Question 15 of 21

What is 3rd level of normalization ?

Total Answers and Comments: 4

Last Update: December 23, 2006

Sponsored Links

Best Rated Answer

—

No best answer available. Please pick the good answer available or submit your answer.

November 03, 2005 02:46:07

Pintu Kumar Singh

RE: What is 3rd level of normalization ?

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.

Is this answer useful? Yes | No

May 05, 2006 15:46:40

Abhishek Mukherjee

RE: What is 3rd level of normalization ?

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.

Is this answer useful? Yes | No

October 23, 2006 11:29:17

thumatinagaraju

Member Since: October 2006 Contribution: 26

RE: What is 3rd level of normalization ?

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

Is this answer useful? Yes | No

December 23, 2006 03:54:14

abhishek mittal

RE: What is 3rd level of normalization ?

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.

Is this answer useful? Yes | No

Go To Top