Question: when bcnf should be applied?
Answer: Rules for BCNF For a table to satisfy the Boyce-Codd Normal Form, it should satisfy the following two conditions: It should be in the Third Normal Form. And, for any dependency A → B, A should be a super key.