Which condition is NOT required for lossless join decomposition?Union of attributes of R1 and R2 must be equal to the attributes of R.Intersection of attributes of R1 and R2 must not be NULL.Common attribute must be a key for both relations R1 and R2.Common attribute must be a key for at least one relation (R1 or R2).

Consider a relation R(A, B, C, D, E) with FD set S = {A ? BC, CD ? E, B ? D, E ? A}. If R is decomposed into two relations, which of the following is a lossless join decomposition?Select one:a. (ABC), (ADE)b. (ABC), (CDE)c. (ABD), (BCE)d. None of the above

Given the following set of FDs on schema R (V,W,X,Y,Z) {Z→V, W→Y, XY→Z, V→WX} State whether the following decomposition are loss-less-join decompositions or not. R1=(V,W,X) , R2=(V,Y,Z) R1=(V,W,X), R2=(X,Y,Z)

R (A, B, C, D) is a relation. Which of the following does not have a lossless join dependency preserving BCNF decomposition?A->B, B->C, C->DAB->C, C->ADA->B, B->CDA->BCD

Consider the relation R={A,B, C, D, E} with the dependencies: {A->D; AB-> C; D->E}.The relation is decomposed into R1(A, B,C) and (A, D, E). The decomposition isa.Non-Lossless joinb.Non-Lossless join and Dependency Presenrvingc.Non-Lossless join and non-Dependency Presenrvingd.Lossless join

What disadvantage is associated with lossless join and dependency preserving decomposition?