Question: Consider the universal relation R = {a, b, c, d, E} and the set of functional dependencies FD = {{a} {b,c},{b} {d}} and MVD =

Consider the universal relation R = {a, b, c, d, E} and the set of functional dependencies FD = {{a} {b,c},{b} {d}} and MVD = {{b} {c,d}

a. Write all the candidate keys for R.

b. What schema(s) would be produced by the 4NF decomposition algorithm?

A. R1={a,b,c,d, E}

B. R1={a,b,c}, R2={b,d}, R3={a,E}

C. R1={b,c}, R2={a,b}, R3={a,d}, R3={a,E}

D. R1={b,d}, R2={b,c}, R3={a,b}, R3={a,E}

E. none of the above

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!