Unformatted text preview: (5) Candidate key(s): A. This is a lossless BCNF Decomposition. This is however not dependency preserving (B consider Æ C). So it is not free of (implied) redundancy. This is not the best decomposition(The decomposition AB, BC, CD is better)...
View Full Document
- Fall '09
- Database normalization, BCNF, Boyce-Codd Normal Form, Third normal form, lossless BCNF Decomposition