RelationalDBDesign
RedhatLinuxSys Seomining
prev next prev next
Course navigation
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:
  1. Verify the table is in 1NF.
  2. Identify the functional dependencies in the table.
  3. Represent those functional dependencies using the determinant -> attributes notation.
  4. 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.
  5. Separate any fields that are not inherent characteristics or foreign keys into new tables, linked by a foreign key.
The next lesson describes the limitations of second normal form.
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
Course navigation