1st Normal Form: There are no repeating or multivalued fields in the table's structure. 2nd Normal Form: All fields are dependant on the entire primary key for their values. 3rd Normal Form: All fields are dependant on ONLY the primary key for their values. Boyce-Codd Normal Form: The table is in 3rd normal form for all feasible candidates for the primary key. 4th Normal Form: There are not independantly multivalued components of the primary key (for tables where the primary key is comprised of two or more component fields). 5th Normal Form: There are no cyclical binary dependencies within the primary key (for tables where the primary key is comprised of three or more component fields).So from this you can see that the structure you described is not wholely a result of normalization. Example: A tabel of books where you have fields like this;