You are viewing a single comment's thread. Return to all comments →
Shouldn't this be BCNF? We have:
i) ac -> b,d ii) ad -> b, and ab is primary key.
1) ac+ = {a,c,b,d} => ac is candidate key 2) ad+ = {a,d,b,c} (ab -> c as ab is primary key) => ad is candidate key so the answer should be 3.5?
Seems like cookies are disabled on this browser, please enable them to open this website
Database Normalization #5
You are viewing a single comment's thread. Return to all comments →
Shouldn't this be BCNF? We have:
i) ac -> b,d ii) ad -> b, and ab is primary key.
1) ac+ = {a,c,b,d} => ac is candidate key 2) ad+ = {a,d,b,c} (ab -> c as ab is primary key) => ad is candidate key so the answer should be 3.5?