Question: Question 4 1 pts Suppose R=(A, B, C, E) and D = {AB, AE} Which is the correct decomposition into 4NF as a result of


Question 4 1 pts Suppose R=(A, B, C, E) and D = {AB, AE} Which is the correct decomposition into 4NF as a result of applying the algorithm described on slide 30? O R1=(AB), R2=(AE), R3=(AC) R1=(AB), R2=(ACE) R1=(ABC), R2=(AE) Suppose we have a table listing movie studios, directors working at a studio, and studio office locations. R=(S, D, L) D={S D, S L} R is not in 4NF since S D and S is not a superkey for R Decomposition a) R, = (S, D) (R, is in 4NF) b) R2 = (S, L) (R2 is in 4NF)
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
