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.
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.
its a partial dependency then how its true
ReplyDelete