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

  • (A) i and ii
  • (B) ii and iii
  • (C) i and iv
  • (D) Professor(professor, project) Professor( professor, project, dept) Student (student no, st_name, dept)
πŸ’¬ Discuss
βœ… Correct Answer: (B) ii and iii

You must be Logged in to update hint/solution

πŸ’¬ Discussion

πŸ“Š Question Analytics

πŸ‘οΈ
117
Total Visits
πŸ“½οΈ
1 y ago
Published
πŸŽ–οΈ
Ranjeet
Publisher
πŸ“ˆ
96%
Success Rate