What is Boyce-Codd Normal Form?

Discussion in 'Databases' started by ptalent, Aug 8, 2009.

0
  1. #1
    What is Boyce-Codd normal form and how is it different from 3rd normal form?
     
    ptalent, Aug 8, 2009 IP
  2. uniqueamrit

    uniqueamrit Peon

    Messages:
    50
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #2
    Refer to Fundamentals of Database Systems(Elmasri Navathe:pearsons Education)
     
    uniqueamrit, Aug 8, 2009 IP
  3. Gamernz

    Gamernz Active Member

    Messages:
    305
    Likes Received:
    3
    Best Answers:
    0
    Trophy Points:
    60
    #3
    Boyce-Codd Normal form is the next step after the third normal form (3NF). Although not common practice in the industry today, for a database table to be Boyce-Codd Normal Form:

     
    Gamernz, Aug 9, 2009 IP
  4. ptalent

    ptalent Peon

    Messages:
    26
    Likes Received:
    2
    Best Answers:
    0
    Trophy Points:
    0
    #4
    Thanks guys :)

    All the information I have found on the 'net and in books (Fundamentals of Database Systems and Database Principles and Design) do seem to be vague and tell me what is NOT BCNF.

    It could just be the taks I've been given that seems simple to put into a regular database structure, but putting it into BCNF based on the examples given in those books, the method doesn't seem to apply.

    I have finished the task and submitted it, but I'll let you guys take a look.

    Sort the following into Boyce-Codd normal form:

    • A recording artist has a unique identifier, a name, a preferred instrument, and a single manager.
    • An artist can make many records and a record can have many artists on it.
    • Each record has a number, a title, a price, a total number of copies sold and is released under a single label

    Artist_ID, Artist_Name, Artist_Instrument, ID, Name, (Record_Number, Record_Title, Record_Price, Copies_Sold, Label_ID, Label_Name)
     
    ptalent, Aug 9, 2009 IP