| | |
Summary: March 23, 2008 DB:Normalization 1
Normalization
March 23, 2008 DB:Normalization 2
Objectives
Introduction +
Objectives of Normalization +
Normal Forms +
The Process of Normalization +
Un Normalized Form (UNF) +
Converting UNF to Normalized Form +
Summary +
March 23, 2008 DB:Normalization 3
- Introduction
A process to validate and improve logical design so that it
satisfies certain constraints that avoid unnecessary
duplication of the data.
Normalization is a formal technique for analyzing a relation
based on its primary key and the FDs between the attributes
of that relation.
The normalization process was first proposed by Codd 1972.
|