Normalization

Running head: NORMALIZATION 1
Normalization
Student_First_Name Student_Last_Name
Institution

NORMALIZATION
Normalization
Fong defines normalization as the process of arranging data in a database to evade data
insertion, update anomaly, deletion anomaly and redundancy (Fong, 2015). Normalization
steps are outlined below:
1. Choose data origin and convert it to un-normalized entity.
2. Transform the un-normalized data to 1NF by the rule of removing any repeated
attributes to a new entity table.
3. Transform the data in 1NF to 2NF by the rule of removing every non-key fields that
are only dependent on part of table to new entity table.
4. Transform the data in 2NF into 3NF by the rule of removing to a new entity any non-
primary key.
Example normalization process
Stu_ID Stu_
Name
Tuitio
n Fees
Paid
($)
Course
Title
Class A Class B Class C
1 Susan
John
400 Medicine Botany 2
2 Scott
Smith
200 Economics Economics
1
Botany 1
3 Matt
Longson
850 Dentistry
4 Mary
Griffin
500 Computer
Engineering
Botany 1 Marketing
Intro
Programming 2
This isn’t a normalized entity, few issues exist within the table as outlined below.
Insert anomaly, which occurs when we insert a record into our table with no good
knowledge of data we are required to know i.e. we are required to add new student info but
we do not know their course title. New row will row will look like this