Specific BCNF decomposition

Asked Mar 16 '14 at 12:46

Active Mar 16 '14 at 12:46

Viewed 157 times

I'm trying to do a BCNF decomposition of the following relation:

R(A,B,C,D,E,F)

with functional dependencies:

A -> DF
B -> AC
F -> E

I get the superkey to B, and by following the decomposition algorithm for BCNF I get the following decomposition:

R1{ADF}, R2{ABC} R3{FE}

However, I suspect that R3 is not correct. Can anyone explain why, and where my error is?

asked Mar 16 '14 at 12:46

NorS

2

B is the only candidate key. Your decomposition is correct. – Mike Sherrill 'Cat Recall' Mar 16 '14 at 13:03
Thank you Mike! I read some more about BCNF and came to the same conclusion. – NorS Mar 16 '14 at 13:56
I guess I should have put that as an answer. – Mike Sherrill 'Cat Recall' Mar 16 '14 at 14:12
Yes. Upvotes on comments don't help you in the REP department. If you care about that. – Erwin Smout Mar 17 '14 at 11:01

0 Answers0