Results 1 to 4 of 4
  1. #1
    Join Date
    Mar 2004
    Posts
    7

    Boyce Codd Normal Form

    Hi,

    I have the following table which I am trying to convert to BCNF (3NF). It represents items in a smart fridge, each item is represented by a row...

    food_id &nbsp &nbsp &nbsp description &nbsp &nbsp &nbsp food_type &nbsp &nbsp &nbsp re-order_level &nbsp &nbsp &nbsp brand &nbsp &nbsp &nbsp expiry_date

    m021 &nbsp &nbsp &nbsp &nbsp &nbsp Mince &nbsp &nbsp &nbsp &nbsp &nbsp &nbsp &nbsp Meat &nbsp &nbsp &nbsp &nbsp &nbsp &nbsp &nbsp &nbsp 3 &nbsp &nbsp &nbsp &nbsp &nbsp &nbsp &nbsp &nbsp Tesco &nbsp &nbsp &nbsp &nbsp &nbsp 28 March

    v055 &nbsp &nbsp &nbsp &nbsp &nbsp Peas &nbsp &nbsp &nbsp&nbsp &nbsp &nbsp &nbsp &nbsp Veg &nbsp &nbsp &nbsp &nbsp &nbsp &nbsp &nbsp &nbsp &nbsp 1 &nbsp &nbsp &nbsp &nbsp &nbsp &nbsp &nbsp &nbsp BirdsEye &nbsp &nbsp &nbsp &nbsp &nbsp 5 May

    m025 &nbsp &nbsp &nbsp &nbsp &nbsp Mince &nbsp &nbsp &nbsp &nbsp &nbsp &nbsp &nbsp Meat &nbsp &nbsp &nbsp &nbsp &nbsp &nbsp &nbsp &nbsp 3 &nbsp &nbsp &nbsp &nbsp &nbsp &nbsp &nbsp &nbsp Tesco &nbsp &nbsp &nbsp &nbsp &nbsp 30 March

    v063 &nbsp &nbsp &nbsp &nbsp &nbsp Chips &nbsp &nbsp &nbsp &nbsp &nbsp &nbsp &nbsp Veg &nbsp &nbsp &nbsp &nbsp &nbsp &nbsp &nbsp &nbsp &nbsp 2 &nbsp &nbsp &nbsp &nbsp &nbsp &nbsp &nbsp &nbsp McCain &nbsp &nbsp &nbsp &nbsp &nbsp 9 September

    v072 &nbsp &nbsp &nbsp &nbsp &nbsp Peas &nbsp &nbsp &nbsp &nbsp &nbsp &nbsp &nbsp veg &nbsp &nbsp &nbsp &nbsp &nbsp &nbsp &nbsp &nbsp &nbsp 2 &nbsp &nbsp &nbsp &nbsp &nbsp &nbsp &nbsp &nbsp Tesco &nbsp &nbsp &nbsp &nbsp &nbsp 8 June

    So far I have made the following tables

    table1 (food_id*, description, food_type, brand, expiry_date)
    table2 (description^, brand^, re-order_level)

    * = primary key
    ^ = foreign key

    I need to know, is this correct and is there any thing more I can do ?

    Any help would be greatly appreciated, im really stuck on this...

    Thanks

    Chris.

  2. #2
    Join Date
    Mar 2004
    Posts
    28

    3rd normal

    Hi,

    Is this for school?
    just an analyst......

  3. #3
    Join Date
    Mar 2004
    Posts
    7
    Yea,

    Its part of a larger assignment. Im really stuck on it at the moment and I need to know if im working in the right direction.

    Chris

  4. #4
    Join Date
    Mar 2004
    Posts
    28

    Re: Boyce Codd Normal Form

    I'll give you a hint.

    Your example is pretty simple. Almost every column could be justified as being in its own table.

    Not quite every all, but almost every one.

    If this were a real world problem, folks would be more inclined to chime in.
    just an analyst......

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •