Normalization:Different forms ,need help in understanding them

Savita Joshi

Savita Joshi

Apr 20 2011 12:04 AM

I have read articles on this but did not understand much. Can someone elaborate the following:

1NF: Eliminate Repeating Groups
Make a separate table for each set of related attributes, and give each table a primary key. Each field contains at most one value from its attribute domain.
2NF: Eliminate Redundant Data
If an attribute depends on only part of a multi-valued key, remove it to a separate table.
3NF: Eliminate Columns Not Dependent On Key
If attributes do not contribute to a description of the key, remove them to a separate table. All attributes must be directly dependent on the primary key..

Need to understand it in detail.. ..


Answers (6)