Answer
See explanation
Work Step by Step
A table is in BCNF if it is in 1st,2nd and 3rd NF and all the determinates are candidate keys.
ORDER_ITEM and ITEM both are in BCNF because the solution to part 2.43b also solved this problem.
Database Concepts
by Kroenke, David; Auer, David;
Published by
Pearson
ISBN 10:
0133544621
ISBN 13:
978-0-13354-462-6
Chapter 2 - The Relational Model - Exercises - Page 109: 2.43D
Update this answer!
You can help us out by revising, improving and updating this answer.
Update this answerAfter you claim an answer you’ll have 24 hours to send in a draft. An editor will review the submission and either publish your submission or provide feedback.
