When you convert an unnormalized table to a table in first normal form, the primary key of the table in first normal form _____.
A) rarely includes a column from the repeating group
B) is usually the primary key of the unnormalized table concatenated with the key for the repeating group
C) rarely includes the primary key of the unnormalized table
D) is usually exactly the same as the primary key of the unnormalized table

Question

Quizplus · Accepted Answer

To convert an unnormalized table to first normal form (1NF), you often need to handle repeating groups of data. The primary key for the table in 1NF typically includes the original primary key from the unnormalized table plus a key to uniquely identify each entry within the repeating group. This ensures that each record in the 1NF table is unique and identifiable.

When You Convert an Unnormalized Table to a Table in First