Normalization means the process in which raw data is

converted to filtered data.

Types of Normalization are:- 1NF,2NF,3NF.

1NF:- Table that contains one or more repeating groups

Identify and remove repeating groups.

2NF:-Describes a table that is fully functionally dependent

Full functional dependency – means that if B is

functionally dependent on A but not on any proper subset of

A, it is fully functionally dependent on A

Partial dependency – is if there are some attributes from A

that can be removed and the dependency still holds

3NF:- In 3NF we remove the transitive dependencies.

Transitive dependency – A->B and B->C implies that A->C

C is transitionally dependent on A through B