1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

About Normalization

Discussion in 'Database' started by bothra_jain, Dec 26, 2005.

  1. bothra_jain

    bothra_jain New Member

    Joined:
    Dec 16, 2005
    Messages:
    6
    Likes Received:
    0
    Trophy Points:
    0
    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 ?
     
  2. shabbir

    shabbir Administrator Staff Member

    Joined:
    Jul 12, 2004
    Messages:
    15,285
    Likes Received:
    364
    Trophy Points:
    83
    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.
     
  3. bothra_jain

    bothra_jain New Member

    Joined:
    Dec 16, 2005
    Messages:
    6
    Likes Received:
    0
    Trophy Points:
    0
    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.
     
  4. shabbir

    shabbir Administrator Staff Member

    Joined:
    Jul 12, 2004
    Messages:
    15,285
    Likes Received:
    364
    Trophy Points:
    83
    Answer I have included the post only.
     

Share This Page