Question

Which option in a table would violate the 1NF rules of normalization?

O Each cell of the table has a single value.
Some cells of the table have multiple values.
The table does not contain repeating groups.
O The table depends on a primary key that is unique.

Answer 1

The option that violates the 1NF rules of normalization is that B. Some cells of the table have multiple values.

What are the 1NF rules of normalization?

This is a normalization form that calls for the deletion of groups of data that are repeating to ensure that redundant data is removed.

If some cells of a table have multiple values therefore, it would mean that there are repeating data which will violate the 1NF rule.

In conclusion, option B is correct.