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.

Answer 1

option 3 is correct one

Answer 2

Complete question:

A relation is said to be in 3 NF if(i) it is in 2 NF (ii) non-key attributes are independent of one another (iii) key attribute is not dependent on part of a composite key (iv) has no multi-valued dependency

A. i and iii

B. i and iv

C. i and ii

D. ii and iv

Answer:

A relation is said to be in 3 NF if C. (i) it is in 2 NF (ii) non-key attributes are independent of one another.

Explanation for the answer:

• A relation R is said to be in second normal form if and only if:
• It is in 1NF, and
• Every non-key attribute is fully dependent on the key attribute or primary key.
• The second normal form is represented by 2NF.
• Hence, the correct answer among all the options is option C. i and ii.

(#SPJ3)