Example of Lossless-Join Decomposition Lossless join decomposition Decomposition of R=(A,B,C) R1=(A,B) R2=(B,C) A B C AB B C A a 1 A B B B 2 12 B r ΠAB() ΠB.c0 C ΠA()凶ΠB(r) A B 1 A B B Database System Concepts-6th Edition 8.7 @Silberschatz,Korth and SudarshanDatabase System Concepts - 6 8.7 ©Silberschatz, Korth and Sudarshan th Edition Example of Lossless-Join Decomposition Lossless join decomposition Decomposition of R = (A, B, C) R1 = (A, B) R2 = (B, C) A B   1 2 A   B 1 2 r B,C(r) A (r) B (r) A B   1 2 C A B B 1 2 C A B C A B A,B(r)