Steps of the normalization process to ensure the 3nf

This preview shows page 10 - 17 out of 17 pages.

Steps of the Normalization Process to Ensure the 3NF Level Normalization is a technique of organizing the data in the database. Normalization is a systematic approach of decomposing tables to eliminate data redundancy and undesirable characteristics. Normalization main purpose is for eliminating redundant (useless) data and ensuring data dependencies make sense and logically stored. Without normalization, it becomes difficult to handle and update the database, without facing data loss. Normalization follows three basic steps, each building on the last.
Database Modeling and Normalization11The first of these steps is the first normal form. First normal form (1NF) sets the fundamental rules for database normalization and relates to a single table within a relational database system. The first normal form states that every column in the table must be unique, separate tables must be created for each set of related data, each table must be identified with a unique column or concatenated columns called the primary key. The first normal form (1NF) involves the removal of repeating groups. For each repeating group encountered, the repeating group is moved to a separate table. “No rows may be duplicated, no columns may be duplicated,no row/column intersections contain a null value, no row/column intersections contain multivalued fields” (Janssen, 2014). Second normal form (2NF) is the second step in normalizing a database. 2NF builds on the first normal form (1NF). A 1NF table is in 2NF form if and only if all of its non-prime attributes are functionally dependent on the whole of every candidate key” (Janssen, 2014). A table that is in first normal form (1NF) must meet additional criteria if it is to qualify for second normal form. To get tables into the second normal form, fields must be analyzed to show the relation to the primary key. There is no redundancy of data (all data is stored in only one place). Data dependencies are logical (all related data items are stored together). A 1NF table is in 2NF form if and only if all of its non-prime attributes are functionally dependent on the whole of every candidate key” (Janssen, 2014).Third normal form (3NF) is the third step in normalizing a database and it builds on the first and second normal forms, 1NF and 2NF. The purpose of going to 3NF is that on this normal form, functional dependencies are eliminated on non-key fields. The rule is to remove a new table any non-key attributes that are more dependent on other non-key attributes than the table
Database Modeling and Normalization12key. Ignore tables with zero or only one non-key attribute (these go straight to 3NF with no conversion). At this stage, all non-key fields are dependent only on the key. Figure 2: Second Normal Form
Database Modeling and Normalization13Figure 3: Second Normal Form
Database Modeling and Normalization14
Database Modeling and Normalization15Figure 4: Third Normal Form
Database Modeling and Normalization16
Database Modeling and Normalization17ReferencesRouse, M. (2007),

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture