Database Normalization - Home Page

Database Normalization, Normal forms 1NF, 2NF, 3NF and BCNF explained, Solved exercises for normalization, links to external sources, Examples

Database Normalization

• Normalization - Introduction

• Modification Anomalies

• First Normal Form (1NF)

• Normal Forms – Simple Definitions for 1NF, 2NF, 3NF and BCNF

• Functional dependency

• Closure in database

• Canonical cover/minimal cover

• Keys that are important to know in normalization process

• Second Normal Form (2NF)

• Third Normal Form (3NF)

• Boyce-Codd Normal Form (BCNF)

• Comparison of different normal forms

• Exercises - Solved exercises and Quizzes

Go to Index page - Advanced DBMS concepts

Normalization in DBMS

Database normalization concepts explained

Solved exercises in normalization

Normalization in DBMS: 1NF, 2NF, 3NF and BCNF

Normal forms in DBMS

Compare different normal forms