Go4Expert

Go4Expert (http://www.go4expert.com/)
-   Database (http://www.go4expert.com/forums/database-forum/)
-   -   About Normalization (http://www.go4expert.com/forums/about-normalization-t540/)

bothra_jain 26Dec2005 15:07

About Normalization
 
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 26Dec2005 19:59

Re: About Normalization
 
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 28Dec2005 16:22

Re: About Normalization
 
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 28Dec2005 19:42

Re: About Normalization
 
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


All times are GMT +5.5. The time now is 04:02.