Which of the following is a problem found with 1NF (first normal form) design that does not exist in 2NF (second normal form)?
A) adding a new record creates difficulties
B) 1NF tables always contain consistent data
C) deleting a record creates difficulties
D) changing a particular entity's description is cumbersome and expensive

Question

Quizplus · Accepted Answer

1NF can have issues with data redundancy and anomalies such as insertion, deletion, and update anomalies. 2NF addresses these by ensuring that all non-key attributes are fully functionally dependent on the primary key, reducing redundancy and associated problems.

Which of the Following Is a Problem Found with 1NF