http://netvouz.com/url/1bbe3065b30fccad6f2673bee6d20772?feed=rss Info about a link http://www.datamodel.org/NormalizationRules.html airpocket Mon, 18 Jun 2007 06:37:43 GMT http://www.datamodel.org/NormalizationRules.html 1NF Eliminate Repeating Groups - Make a separate table for each set of related attributes, and give each table a primary key. 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. BCNF Boyce-Codd Normal Form - If there are non-trivial dependencies between candidate key attributes, separate them out into distinct tables. 4NF Isolate Independent Multiple Relationships - No table may contain two or more 1:n or n:m relationships that are not directly related. 5NF Isolate Semantically Related Multiple Relationships - There may be practical constrains o emweb Mon, 02 Apr 2007 09:31:29 GMT http://www.datamodel.org/NormalizationRules.html Rules of Data Normalization Page ajaygodbole Sun, 14 May 2006 12:23:01 GMT