UTpaper

Free mock tests & test series

Question 68Asked in UGC NET Computer Science, November 2017 (Paper II & III, Selected Questions)

If every non-key attribute is functionally dependent on the primary key, then the relation is in _____

  1. AFirst normal form
  2. BSecond normal form
  3. CThird normal form
  4. DFourth normal form
Show answerHide answer

Correct answer: (B) Second normal form

Explanation

A relation is in 2NF if it is in 1NF and every non-key attribute is fully functionally dependent on the primary key. If every non-key attribute is functionally dependent on the primary key (no partial dependency), the relation is in second normal form.

From UGC NET Computer Science PYQ, November 2017 (Paper II & III, Selected Questions)

This is question 68 of UGC NET Computer Science PYQ, November 2017 (Paper II & III, Selected Questions). See all questions of this paper with answers, or attempt the paper as a timed online test to get your score and all-India rank.