Second normal form means ____.
A) calculated fields are removed
B) redundant data is extracted into a new table
C) totals are removed
D) a single table with rows and columns

Question

Quizplus · Accepted Answer

Second normal form (2NF) requires that the table is in first normal form (1NF) and that all non-key attributes are fully dependent on the primary key. This means that no data should be unnecessarily replicated within the table, and if there are attributes that depend on only a portion of the primary key, they should be moved to a separate table. Therefore, option B is correct as it involves extracting redundant data into a new table.

Second Normal Form Means ____