Results 1 to 2 of 2
  1. #1
    Join Date
    Feb 2004

    Boyce-codd Normal Form

    I have seen many descriptions of Boyce-Codd Normal Form, however none make any sense. Can somebody explain this in easy terms?

  2. #2
    Join Date
    Sep 2003
    The extremely Royal borough of Kensington, London
    R(supplier_id, part_id, supplier_name, qty)


    (supplier_id, part_id)
    (supplier_name, part_id)

    The following constraint is given:
    supplier_id => supplier_name, supplier_name => supplier_id

    Therefore the relation R does not violate 3NF, however it violates BCNF.

    To solve:

    R1(supplier_id, part_id, qty) key (supplier_id, part_id)
    R2(supplier_id, supplier_name) key (supplier_id), UNIQUE(supplier_name)
    Bessie Braddock: Winston, you are drunk!
    Churchill: And Madam, you are ugly. And tomorrow, I'll be sober, and you will still be ugly.

Posting Permissions

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