The conversion of an unnormalized table to first normal form requires the removal of ____.
A) determinants
B) interrelation constraints
C) nonkey columns
D) repeating groups

Question

The conversion of an unnormalized table to first normal form requires the removal of ____.​
A) ​determinants
B) ​interrelation constraints
C) ​nonkey columns
D) ​repeating groups

Quizplus · Accepted Answer

To convert an unnormalized table to first normal form, the repeating groups should be removed. Repeating groups refer to the columns that contain multiple values within a single record. Removing these repeating groups involves creating a separate table for each set of related values, and establishing a relationship between the new tables and the original table using a foreign key. The removal of determinants, interrelation constraints or nonkey columns is not specifically required for first normal form conversion.

The Conversion of an Unnormalized Table to First Normal Form