The preceding lessons described how to put a table in second normal form.
To review, that process is:
Verify the table is in 1NF.
Identify the functional dependencies in the table.
Represent those functional dependencies using the
determinant -> attributes notation.
Use your knowledge of the business objects in the ER diagram to identify any fields that are not either:
- inherent characteristics of the object represented by the table, or
- foreign keys used to link the table to other tables.
Separate any fields that are not inherent characteristics or foreign keys into new tables, linked by a foreign key.
Before you move on to the next lesson, complete the following exercise to reinforce your understanding of second normal form.
Second Normal Form - Exercise