Normalization

Quotes from



The Art of SQL, written by Stephane Faroult



Chapter 1.2. The Importance of Being Normal

http://my.safaribooksonline.com/0596008945/artofsql-CHP-1-SECT-2



1.2.1. Step 1: Ensure Atomicity

1.2.2. Step 2: Check Dependence on the Whole Key



1.2.3. Step 3: Check Attribute Independence

3NF is reached when we cannot infer the value of an attribute from any attribute other than those in the unique key. For example, the question must be asked: "Given the value of attribute A, can the value of attribute B be determined?"