Question

What is the purpose of conducting normalization to a relational database?

Use examples to explain your answer.

Answer 1

Hi,

I am happy to help you with this question.

In this question we have to provide the reasons for conducting normalization in a relational database.

The basic purpose for normalizing the database is for main three reasons:

1) To remove the redundancy: By normalization we remove the redundant database , for example: We have multiple duplicate data so we normalize it by breaking it into simple forms thus, we get an efficient database.

2)To remove anomalies(insertion ,updation,deletion): By normalizing we simply organize the relational database by separating different tables .

This breakage saves data duplication .

3) It increases the efficiency and performance : due to duplicate values in a relational database , it makes it difficult to perform queries but by normalization this problem is solved since the queries give faster results improving the performance of the database.

Let me explain you with an example,

R(A,B,C) IS A relation with A, B,C attributes .

A->B,

B->C,

AB->c,

This contains a redundant property so we break it into parts which obliges the 2nf form .

The result is R1(AB), R2(BC),R3(ABC) .this form of tables are not redundant thus helps in improving the efficiency.

Thank you.

I hope i was able to help you . If you have any queries please be comfortable to ask in the comments ,i will be glad to help you.

:).