Question

A database designer is refining a relation that has a composite primary key. Some non-key attributes depend only on part of this key, leading to redundancy. Removing such dependencies ensures the relation satisfies a higher normal form. The correct statement describing this transformation is _______.

• A. First Normal Form (1NF) allows repeating groups and multi-valued attributes
• B. Second Normal Form (2NF) eliminates partial dependencies on a composite key
• C. Third Normal Form (3NF) allows transitive dependencies
• D. Boyce-Codd Normal Form (BCNF) is weaker than 3NF

Hint:

Partial dependencies are only possible if you have a composite primary key. If your primary key consists of only one column, the table is automatically in 2NF (provided it is already in 1NF).

Answer 1

The Correct Option is B