Data normalization allows repeating groups such as the same vendor name in multiple locations of the primary key field of the same table.

Question

Quizplus · Accepted Answer

Data normalization involves removing repeating groups and ensuring atomicity of data. The primary key field should not contain repeating groups, as it violates the first normal form. Instead, a separate table should be created for the repeating group with a foreign key relationship to the original table.

Data Normalization Allows Repeating Groups Such as the Same Vendor