NORMAL FORM II : LSUS

DATA PROCESSING SSS2 FIRST TERM           

WEEK 8

NORMAL FORM II

Contents

Types of Normal Form

First Normal Form (1NF)

First Normal Form (1NF) says that all column values must be atomic. 1NF dictates that for every row-by-column position in a given table, there exists only one value, not an array or list of values i.e in 1NF, the following rules are observed;

      1.  

1. Eliminating repeating information

2. Create separate tables for related data.

 

Second Normal Form (2NF)

The second normal form (2NF) further addresses the concept of removing duplicate data. The rule for the second normal form is;

        1.  

1. Remove subsets of data that apply.... View More

Subscribe now to gain full access to this lesson note

Take Me There

Click here to gain access to the full notes.