Before talking about the concept of normalization, first let’s understand what problem normalization solves.
Let’s take example of Teacher table. It tells us which teacher takes class of which subject.
You can see there is lot of redundancy in the Teacher table. There is duplication of data. There will be problem in inserting, updating and deleting the data due to redundancy.
To solve this problem, the concept of normalization comes into picture.
Table of Contents
Normalization is the process of organizing data in database. Its objective to remove redundancy and data dependence i.e. to place related data in one table. It helps in removing operational anomalies. This concept was first introduced by Edgar Frank Codd.
For example, it is irrelevant to store the Customer information in Employee table.
Let’s take example of Teacher table above; three types of anomalies can occur in this table:
Normalization removes these anomalies by application of various normal forms to decompose the table into multiple tables. We will see discuss various normal forms in another article.
Download as PDF
Read next: First Normal Form (1NF) ››
« Back to Course page
SBI Clerk Course 2023
ECGC PO Course 2023
SIDBI Grade A Course 2023
RBI Assistant Course 2023
SSC CHSL Course 2023
DSSSB JE Electrical 2023
Punjab Civil Services 2023
ESIC Deputy Director 2023