RelationalDBDesign 




Database Analysis   «Prev  Next»
Lesson 12

First, second, and third Normal Forms Conclusion

This module covered database normalization up to 2NF. It identified the requirements of, and procedures for reaching, 1NF and 2NF.
Along the way, it introduced the concepts of normalization, repeating groups, and functional dependencies.

Topics covered in this module:

  1. Define normalization: normalization is the process of applying increasingly stringent rules to a relational database to correct any problems associated with poor design.
  2. Explain requirements for first normal form (1NF)
    first normal form (1NF): A table is in first normal form if it contains no repeating groups.
  3. Describe the limitations of 1NF:
  4. Identify repeating groups: When an attribute has more than one value in a table row it is called repeating groups .
  5. Explain the requirements for second normal form (2NF)
    Second normal form (2NF): A table is in second normal form when every attribute is functionally dependent on the entire primary key.
  6. Identify functional dependency: A one-way relationship between two attributes so that, for any unique value of one attribute, there is only one value of the other attribute.
  7. Describe the limitations of 2NF


Glossary terms

  1. normalization: The process of applying increasingly stringent rules to a relational database to correct any problems associated with poor design.
  2. First normal form (1NF): A table is in first normal form if it contains no repeating groups.
  3. Repeating groups: An attribute that has more than one value in a table row.
  4. second normal form (2NF): A table is in second normal form when every attribute is functionally dependent on the entire primary key.
  5. functional dependency: A one-way relationship between two attributes so that, for any unique value of one attribute, there is only one value of the other attribute.
  6. multi-field determinant: A determinant consisting of more than one field.
  7. concatenated primary key: A primary key made up of more than one field.
  8. requirements analysis: The stage in the database design cycle when designers find out everything they can about the data the client needs to store in the database and the conditions under which that data needs to be accessed.
  9. normal form: A set of theoretical rules for the design of database tables.
  10. denormalization: To move a table to a lower normal form (e.g., from 3NF to 2NF).
  11. The next module describes third normal form.

Normalization - Quiz

Before you move on to the next module, take the following quiz to check your knowledge of normalization to 2NF.
Normalization - Quiz