UTpaper

Free mock tests & test series

Question 62Asked in UGC NET Computer Science, June 2015 (Paper II & III, Selected Questions)

The Relation Vendor Order (V_no, V_ord_no, V_name, Qty_sup, unit_price) is in 2NF because :

  1. ANon_key attribute V_name is dependent on V_no which is part of composite key
  2. BNon_key attribute V_name is dependent on Qty_sup
  3. CKey attribute Qty_sup is dependent on primary_key unit price
  4. DKey attribute V_ord_no is dependent on primary_key unit price
Show answerHide answer

Correct answer: (A) Non_key attribute V_name is dependent on V_no which is part of composite key

Explanation

Option (a) is which it is clearly mentioned that partial dependency exists is against 2NF principle. Question seems incomplete, because there is nothing said about functional dependency.

From UGC NET Computer Science PYQ, June 2015 (Paper II & III, Selected Questions)

This is question 62 of UGC NET Computer Science PYQ, June 2015 (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.