UGC-NET | UGC NET CS 2015 Jun – III | Question 10

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


Article Tags :

Be the First to upvote.


Please write to us at contribute@geeksforgeeks.org to report any issue with the above content.