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

Boyce-Codd normal form

Discussion in 'Database' started by Lizapotter, Feb 24, 2009.

  1. Lizapotter

    Lizapotter New Member

    Joined:
    Feb 24, 2009
    Messages:
    17
    Likes Received:
    5
    Trophy Points:
    0
    Occupation:
    Web Design London
    Location:
    UK
    Home Page:
    Can anybody explain to me what is Boyce-Codd normal form (or BCNF) ? What is it's importance in database design and how a table can be in BCNF form
     
  2. shabbir

    shabbir Administrator Staff Member

    Joined:
    Jul 12, 2004
    Messages:
    15,283
    Likes Received:
    364
    Trophy Points:
    83
    Boyce-Codd normal form (or BCNF) is a slightly stronger version of the third normal form (3NF).

    A table is in Boyce-Codd normal form if and only if, for every one of its dependencies X → Y, X is a superkey
     

Share This Page