Normalization Rules
1st Normalization RuleBreak each field into smallest meaningful value. Remove repeating groups of data create separate table for each set of related data.
2nd Normalization Rule
Create New tables for data that applies to more than one record in a table. Add related field (Foreign key) to the table.
3rd Normalization Rule
Remove fields that do not relate to or provide a fact about the Primary Key
