When converting a non-first normal form table to first normal form, the foreign key will usually include the original foreign key concatenated with the key to the repeating group.

Question

Quizplus · Accepted Answer

When converting a non-first normal form table to first normal form, the repeating group should be assigned a separate table and the foreign key in the original table should only include the original foreign key, not the key to the repeating group.

When Converting a Non-First Normal Form Table to First Normal