Good Decomposition

Lossless-Join

Dependency Preserving

Normal Form

Summary

Functional dependencies provide clues towards elimination of redundancies in a relational schema
Goals: To repair relational schemata by decomposition which is

  1. Not lossy
  2. Dependency Preserving
  3. For which each resulting table is in BCNF or 3NF