Scribd
Upload
11 views2 pages

Normalization Blended Learning

Normalization is a database technique that organizes data to eliminate redundancy and improve management by splitting large tables into smaller, linked ones. It consists of three main steps: 1NF ensures each cell has a single value, 2NF requires all data to depend on the primary key, and 3NF mandates that data only depends on the primary key. While normalization enhances data cleanliness and reduces storage needs, it may slow down queries due to the increased number of tables.

Uploaded by

Dharsh Dhaarsini
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
11 views2 pages

Normalization Blended Learning

Normalization is a database technique that organizes data to eliminate redundancy and improve management by splitting large tables into smaller, linked ones. It consists of three main steps: 1NF ensures each cell has a single value, 2NF requires all data to depend on the primary key, and 3NF mandates that data only depends on the primary key. While normalization enhances data cleanliness and reduces storage needs, it may slow down queries due to the increased number of tables.

Uploaded by

Dharsh Dhaarsini
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd

1.

 Normalization is a way to arrange data in a neat and proper way in a


database.
 It helps to remove repeated data and avoid mistakes in data.
 It splits big tables into smaller ones that are linked together.
 There are three main steps (called normal forms):

 1NF – Make sure each box (cell) has only one value.

 2NF – All the data should depend on the main key (important ID).

 3NF – The data should depend only on the main key, not on other
data in the table.

 Why we use normalization:

 Makes data cleaner and easier to manage.

 Saves storage space by not repeating things.

 Makes it easier to find and update information.

 But sometimes it makes queries slower because the data is in many


small tables.

2.
1NF (First Normal Form)

 Each column should have only one value, not a list.

 No repeating groups.

 Every row must be different.

2NF (Second Normal Form)

 Must be in 1NF first.

 All other columns must depend on the whole primary key, not just
part of it.

 Removes repeated info that depends only on part of the key.

3NF (Third Normal Form)

 Must be in 2NF first.

 All columns must depend only on the primary key.

 No column should depend on another column that isn’t the key.

Normalization helps to:

 Organize data properly

 Avoid repeating the same data

 Make updates easier and safer

You might also like