Database Normalization

Normalization is a process to bifurcate the excel data or bunch of data into different tables and makes a relationship between those tables.

Normalization is the process of structuring and refining the data we want to store in such a way that we eliminate repeated information and represent as much connection between records as possible.

Here is a very fine article which explains the whole idea.