Let R(A,B,C,D,E,F,G) be a relation with FDs F= {C→ EF, EG-→ D, DG→ A, A→ B} that hold on R. Which of the following is a 3NF decomposition of R that is lossless and dependency preserving? Select one: O...


Let R(A,B,C,D,E,F,G) be a relation with FDs<br>F= {C→ EF, EG-→ D, DG→ A, A→ B} that hold on R.<br>Which of the following is a 3NF decomposition of R that is lossless and dependency preserving?<br>Select one:<br>O R1(A, B, D, G), R2(D, E, G) and R3(C, E, F)<br>None of the four decompositions.<br>R1(A, D, E, G), R2(A, B, C, E, F)<br>R1(D, E, G), R2(A, D, G), R3(A, B) and R4(C, E, F)<br>O All of the four decompositions.<br>O R1(A, D. E. G), R2(A, B) and R3(C, E, F)<br>

Extracted text: Let R(A,B,C,D,E,F,G) be a relation with FDs F= {C→ EF, EG-→ D, DG→ A, A→ B} that hold on R. Which of the following is a 3NF decomposition of R that is lossless and dependency preserving? Select one: O R1(A, B, D, G), R2(D, E, G) and R3(C, E, F) None of the four decompositions. R1(A, D, E, G), R2(A, B, C, E, F) R1(D, E, G), R2(A, D, G), R3(A, B) and R4(C, E, F) O All of the four decompositions. O R1(A, D. E. G), R2(A, B) and R3(C, E, F)

Jun 06, 2022
SOLUTION.PDF

Get Answer To This Question

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here