recategorized by
3,314 views
4 votes
4 votes

The Relation

Vendor Order (V_no, V_ord_no, V_name, Qty_sup, unit_price) is in 2NF because

  1. Non_key attribute V_name is dependent on V_no which is part of composite key
  2. Non_key attribute V_name is dependent on Qty_sup
  3. Key attribute Qty_sup is dependent on primary key unit_price
  4. Key attribute V_ord_no is dependent on primary key unit_price
recategorized by

2 Answers

6 votes
6 votes
this question and its ans given by CBSE irritates me regularly   ans given is option A  in which it is clearly mentioned that partial dependency exists which is against 2NF principle.

Rest options do not give any clue or something substantial to conclude anything

B either true or false does not ensure anything and so is C,D
2 votes
2 votes
3 & 4 impossible coz 2nd normal form says about non-key dependency on something 1 is exact violation of 2nf so 1 may ensure the def'n of 2nf from it. b is in b/w no data about the attr. mentioned.
Answer:

Related questions