Tuesday 24 November 2015

Q10,P3,J15. The Relation

vendor order(v_no,v_ord_no,v_name,qty_sup,unit_price) is in 2nf because:
options
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.

1 comment:

Note: only a member of this blog may post a comment.