Subscribe

RSS Feed (xml)

Powered By

Skin Design:
Free Blogger Skins

Powered by Blogger


Friday, September 16, 2011

What are levels of Normalization

The first three levels in normalising a database are:
First Normal Form (1NF): There should be no repeating groups in a table.
Second Normal Form (2NF): No non-key fields may depend on a portion of the primary key.
Third Normal From (3FN): No fields may depend on other non-key fields. In other words, each field in a record should contain information about the entity that is defined by the primary key.

No comments:

Post a Comment