This preview shows page 1. Sign up to view the full content.
Unformatted text preview: a D id , P a DC Original FDs: P a-> P id , P id-> D id , P id D -> Q, DQ -> C c. F = P a-> P id , P id -> D id , P id D -> Q, DQ -> C d. P a P id and P id D id are automatically OK. Need to check P id D -> Q and DQ -> C. Because they are in the original FDs, that means that they are OK as well. This decomposition is in BCNF....
View Full Document
This note was uploaded on 01/09/2012 for the course CSE 132A taught by Professor Alindeutsch during the Spring '08 term at UCSD.
- Spring '08