September 22, 2018, 7:25 PM : Please sign in or register for a free account. Get information about membership.
Who's chatting now:
Feature: Home

Database Normalization
By Swiftmember has saluted, click to view salute photos
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.


ReplySendWatch

Powered by XP Experience Server.
Copyright ©1999-2018 XP.COM, LLC. All Rights Reserved.
XL
LG
MD
SM
XS
XL
LG
MD
SM
XS