November 24, 2017, 3:01 PM : Please sign in or register for a free account. Get information about membership.
Who's chatting now:
Feature: Home

Database Normalization en>fr fr>en
By Swiftmember has saluted, click to view salute photos Comments: 106, member since Fri Feb 22, 2002
On Thu Sep 26, 2002 09:17 AM
What is database normalization and why is it necessary?

Database normalization is a method to organize tables in a relational database to eliminate redundancy and preserve integrity.

There are different stages of normalization with each stage building upon the prior stage.

First normal form (1NF) requires that each column contain atomic data and that no groups are repeated.

Second normal form (2NF) requires that non-key attributes be based on the entire key.

Third normal form (3NF) requires that all non-key attributes be based on the primary key.