• Main Menu
  • Database Normalization


    Database normalization is the process of organizing data into distinct and unique sets.

    The purposes of normalization are to:

    • Reduce or eliminate storage of duplicate data
    • Organize data into an efficient and logical structure

    The process of normalization involves determining what data should be stored in each database table.

    By tradition, the process of normalization involves working through well-defined steps, called normal forms.

    In First Normal Form (1NF) you eliminate duplicate columns from the same table, create separate tables for each group of related data, and identify each row with a unique column or set of columns (the primary keys).Database Normalization

    In Second Normal Form (2NF) you remove subsets of data that apply to multiple rows of a table, place them in separate tables, and create relationships between these new tables and the original tables through the use of foreign keys.

    In Third Normal Form (3NF) you remove columns that are not dependent upon the primary key.

    Additional normal forms have been defined, but are less commonly utilized. These advanced normal forms include Fourth Normal Form (4NF), Fifth Normal Form (5NF), Boyce Codd Normal Form (BCNF), and Domain-Key Normal Form (DK/NF).

    Got Something To Say:

    Your email address will not be published. Required fields are marked *

    One comment
    1. Abicus

      29 November, 2011 at 1:13 am

      1)     Describe and illustrate the process of normalization for the following relation to Second (2NF), and Third (3NF).
       
      R(ABCDEF)
       
      A->B
      D->E
      B->C
      E->F

      Reply
    Databases
    177 queries in 0.487 seconds.