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
Article Tags :
Recommended Articles