| Lesson 10 | Achieving 2NF |
| Objective | Describe the process for achieving 2NF. |
The preceding lessons described how to put a table in second normal form.
To review, that process is:
The next lesson describes the limitations of 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: (1) inherent characteristics of the object represented by the table, or (2) 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.
Second Normal Form - Exercise
Before you move on to the next lesson, complete the following exercise to reinforce your understanding of second normal form.
Second Normal Form - Exercise
Second Normal Form - Exercise