Decomposing a Schema into BCNF Suppose we have a schema R and a non-trivial dependency a> causes a violation of BCNF. We decompose R into: ·(aUB) °(R-(B-a) In our example, a=loan number B=amount and bor loan is replaced by (a UB)=(loan_number,amount) (R-（B-u)）=(customer_id,loan_number) Database System Concepts-5th Edition,Oct 5,2006 7.18 ©Silberschat乜，Korth and SudarshanDatabase System Concepts - 5 7.18 ©Silberschatz, Korth and Sudarshan th Edition, Oct 5, 2006 Decomposing a Schema into BCNF Suppose we have a schema R and a non-trivial dependency  → causes a violation of BCNF. We decompose R into: • ( U  ) • ( R - (  -  ) ) In our example,  = loan_number  = amount and bor_loan is replaced by ( U  ) = ( loan_number, amount ) ( R - (  -  ) ) = ( customer_id, loan_number )