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

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

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!