BCNF (continued)

• Decomposition: R1 (banker, branch) and R2 (cust, banker)

  • avoids redundancy and other problems
  • A problem remains:

• In this case, no dependency-preserving decomposition into BCNF is possible.

Previous slide

Next slide

Back to first slide

View graphic version