1

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

Correct Answer: i and ii

Make the most of this question

This page focuses on one Database Management System (DBMS) question from Engineering. After checking the answer, return to the topic list to practice more or run a timed set.

Database Management System (DBMS) MCQ: 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 | Extra Education