Powered By Blogger

Monday 27 February 2012

Normalization


Level
Rule
An entity type is in 1NF when it contains no repeating groups of data.
An entity type is in 2NF when it is in 1NF and when all of its non-key attributes are fully dependent on its primary key.
An entity type is in 3NF when it is in 2NF and when all of its attributes are directly dependent on the primary key.

No comments: