Question

If every non-key attribute is functionally dependent primary key, then the relation will be in

(a) First normal form

(b) Second normal form

(c) Third form

(d) Fourth normal form

This question was addressed to me in unit test.

The origin of the question is Atomic Domains topic in chapter Database Systems Design and Implementation of Database Management

Answer 1

Correct option is (b) Second normal form

Easy explanation - Third normal form (3NF) relaxes this constraint slightly by allowing certain nontrivial functionaldependencieswhose left side is not a superkey.