Database Normalization

Overview

Introductions

Why Normalize?

Normalization Defined

Another Definition

The Normal Forms

First Normal Form (1NF)

Second Normal Form (2NF)

Third Normal Form (3NF)

Boyce-Codd Form (3NF) - Examples

Primary Key

Relationships

Table Prefixes Aid Development

Referential Integrity

When Not to Normalize

Real World - School Data

One Possible Design

Books

Internet