DBMS

Page 1

Normalization

Is a process of reducing redundancy by organizing the data into multiple tables. Normalization leads to better usage of disk spaces and makes it easier to maintain the integrity of the database.

Denormalization

is the reverse process of normalization as it combines the tables which have been normalized into a single table so that data retrieval becomes faster. JOIN operation allows us to create a denormalized form of the data by reversing the normalization.

1NF: It is known as the first normal form -> is the simplest type of normalization that you can implement in a database. -> A table to be in its first normal form should satisfy the following conditions:

Every column must have a single value and should be atomic.

Duplicate columns from the same table should be removed.

Separate tables should be created for each group of related data and each row should be identified with a unique column.

2NF: It is known as the second normal form. A table to be in its second normal form should satisfy the following conditions:

The table should be in its 1NF i.e. satisfy all the conditions of 1NF.