When the analyst is evaluating a data model to ensure that all fields in a record depend fully on the entire primary key,which step of normalization is being performed?
A)base normal form
B)first normal form
C)second normal form
D)third normal form
E)cannot tell from the above information

Question

Quizplus · Accepted Answer

Second normal form (2NF) requires that all non-key attributes are fully functionally dependent on the entire primary key, which means no partial dependency on any subset of the primary key.

When the Analyst Is Evaluating a Data Model to Ensure