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:
    http://www.codastar.com/
    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,375
    Likes Received:
    388
    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

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice