• INTRODUCTION
• ROLE OF NORMALIZATION
• SINGLE-VALUED DEPENDENCIES
  • Functional Dependency
  • Closure
  • Equivalent FDs
  • Minimal FDs (Minimal Covers)
• SINGLE VALUED NORMALIZATION
  • First Normal Form (1NF)
  • Second Normal Form (2NF)
  • Third Normal Form (3NF)
  • Boyce-Codd Normal Form (BCNF)
• DESIRABLE PROPERTIES OF DECOMPOSITIONS
  • Attribute Preservation
  • Lossless-Join Decomposition
  • Dependency Preservation
  • Lack of Redundancy
  • Deriving BCNF
• MULTIVALUED DEPENDENCIES
  • Multivalued Normalization --- Fourth Normal Form
  • Fifth Normal Form
• REFERENCES

Test Your Knowledge

• EXERCISES
• Quiz