next up previous
Next: Normalization Using Multivalued Dependencies Up: Normalization Using Functional Dependencies Previous: Third Normal Form

Comparison of BCNF and 3NF

  1. We have seen BCNF and 3NF.
  2. These problems can be illustrated with Banker-schema.
  3. If we must choose between BCNF and dependency preservation, it is generally better to opt for 3NF.
  4. To summarize, our goal for a relational database design is
  5. If we cannot achieve this, we accept
  6. A final point: there is a price to pay for decomposition. When we decompose a relation, we have to use natural joins or Cartesian products to put the pieces back together. This takes computational time.

Osmar Zaiane
Thu Jun 18 12:56:34 PDT 1998