Question

A relation is said to be in 2 NF if

(i)it is in 1 NF
(ii)non-key attributes dependent on key attribute
(iii)non-key attributes are independent of one another
(iv)if it has a composite key, no non-key attribute should be dependent on Part of the composite key.

(a)i, ii, iii
(b)i and ii
(c)i, ii, iv
(d)i, iv

Answer 1

(b)i and ii

Step-by-step explanation:

A relation is in the second normal form if it fulfills the following two requirements:

1. It is in first normal form.
2. It does not have any non-prime attribute that is functionally dependent on any proper subset of any candidate key of the relation. A non-prime attribute of a relation is an attribute that is not a part of any candidate key of the relation.

From the above definition, it is only (i) and (ii) that satisfy the definition.