R represent Table, and (a, b, c, d) represent columns in the table.

Since all the values are atomic and we have a given primary key(a, b) we can say it is in the 1NF.

But a, c -> b, d ( meaning b, d can be determined from a, c). Here we have partial dependency, since (b, d) is not being fully dependent on the primary key (a, b), even though the answer turn out to be incorrect.

But

www.cricbet99id.org

Answer: 3

the answer is 3

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?