Posted on 2006-06-24
I don't have a formal background in relational theory and I'm trying to get a better understanding of normalization. I'm trying to find examples and more information on 1nf - 3nf, which seems to be appropriate for many smaller applications. I want to get a good handle on these.
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.
Can anyone point me to some good resources.