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
An unexpected error occurred. Please try reloading the page. If problem persists, please contact support@hackerrank.com
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?