Q. Given the relation Supplier(s_id, p_order, s_name, qty) Given that there is a unique s_name for each s_id and that s_id, p_order is a composite key, find the correct statement among the following: i. this relation is a BCNF ii. this is 3 NF relation iii. this is a 2 NF relation iv. this is a 1 NF relation (Solved)

1. i and ii

2. ii and iii

3. i and iv

4. i and iii

  • d. i and iii
Subscribe Now

Get All Updates & News