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 this information

Question

Quizplus · Accepted Answer

This is the definition of Second Normal Form (2NF), which requires that all non-prime attributes are fully functionally dependent on the primary key. This step is taken after achieving First Normal Form, where all attributes must be atomic, and it addresses the issue of partial dependency in composite primary keys.

When the Analyst Is Evaluating a Data Model to Ensure