Chapter 5, Problem 5.3RQ

Explanation of Solution

Normalization:

In database management system, normalization is a technique of organizing the data in the database without any redundancy. Redundancy in relation may cause deletion, insertion, and update anomalies.

Normalization is mainly used for two purposes. They are:

• Reduce or eliminate redundancy in the database table.
• Ensuring data dependencies.

Importance of Normalization process:

• The normalization process is important while creating a table in the database, because the process will eliminate the redundancy of data in the database table.
• The normalization process is then applied to each relation and the extra relations are created.

Example:

Consider the example of the above scenario is as follows:

number	name	age	sex	course
1	John	23	M	C1
2