Question

1NF to 2NF means to remove _____

a) Duplicate rows
b) Duplicate columns
c) Partial dependencies
d) NULL values

Answer 1

1NF to 2NF means removing partial dependencies in database normalization by moving attributes that depend on only part of the primary key to a separate table.

Step-by-step explanation:

1NF to 2NF means to remove partial dependencies which are functional dependencies where an attribute is functionally dependent on only part of a multi-valued key.

1. 1NF is the first normal form in database normalization and it requires each row to have a unique primary key and no repeating groups.
2. 2NF is the second normal form and it requires eliminating partial dependencies by moving attribute(s) that depend on only part of the primary key to a separate table.