Skip to content
Related Articles

Related Articles

UGC-NET | UGC NET CS 2015 Jun – III | Question 10
  • Last Updated : 19 Jun, 2018

The Relation
Vendor Order (V_no, V_ord_no, V_name, Qty_sup, unit_price) is in 2NF because:
(A) Non_key attribute V_name is dependent on V_no which is part of composite key
(B) Non_key attribute V_name is dependent on Qty_sup
(C) Key attribute Qty_sup is dependent on primary_key unit price
(D) Key attribute V_ord_no is dependent on primary_key unit price


Answer: (A)

Explanation: The Relation
Vendor Order (V_no, V_ord_no, V_name, Qty_sup, unit_price) is in 2NF because:
Non_key attribute V_name is dependent on V_no which is part of composite key.
For more information on Normal forms Refer:Database Normalization | Normal Forms
Option (A) is correct.

Quiz of this Question

My Personal Notes arrow_drop_up
Recommended Articles
Page :