Chapter 1, Problem 8RQ

Explanation of Solution

Normalization process:

The process used to minimize data redundancy and dependency in a relational database is known as normalization. The database table is divided into two or more tables and defines the relationship between those tables.

 Steps of normalization process:

 First, a primary key is identified and any repeating groups are identified (1NF). Second, any partial dependencies are eliminated (2NF). Third, any transitive dependencies are eliminated (3NF).

 First-Normal Form (1NF):

• If a table does not contain any replicate fields or groups of fields then that model is called as first normal form.
• In this form, entities do not contain any single instance of the repeating variable.
  • It means that the entities contain only one instance of the attributes, multi-valued attributes are neglected...