Normalization Using Functional Dependencies

We can use functional dependencies to design a relational database in which most of the problems we have seen do not occur.

Using functional dependencies, we can define several normal forms which represent ``good'' database designs.

• Desirable Properties of Decomposition
  • Lossless-Join Decomposition
  • Dependency Preservation
  • Repetition of Information
• Boyce-Codd Normal Form
• Third Normal Form
• Comparison of BCNF and 3NF