About Normalization

bothra_jain's Avatar, Join Date: Dec 2005
Light Poster
As we know the level of normalization is 1st ,..BCNF,...5th NF; May anyone tell me why the name BCNF is given in place of 6th/7th NF or any nth NF ?
shabbir's Avatar, Join Date: Jul 2004
Go4Expert Founder
BCNF is Boyce-Codd Normal form and so the name BCNF is given. Its a special case of normal form which does not occur in all situation as the cases of 1st - 5th ...NF occurs.
bothra_jain's Avatar, Join Date: Dec 2005
Light Poster
Thank u, actually I want to know that why the name given BCNF ( Boyce-Codd Normal Form) rather than any nTh NF? Where n may be any numeric value.
shabbir's Avatar, Join Date: Jul 2004
Go4Expert Founder
Quote:
Originally Posted by bothra_jain
Thank u, actually I want to know that why the name given BCNF ( Boyce-Codd Normal Form) rather than any nTh NF? Where n may be any numeric value.
Answer I have included the post only.
Quote:
Its a special case of normal form which does not occur in all situation as the cases