NORMAL FORM II

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. 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. 1. 1.  

1. Remove subsets of data that apply to multiple rows of a table and place them in a separate…