418 views

1 Answer

Best answer
2 votes
2 votes

R(A,B,C,D,E) {A $\rightarrow$ B , AB $\rightarrow$ C, D $\rightarrow$ AC, D $\rightarrow$ E}

R1(A,C,D){ D $\rightarrow$ AC , A $\rightarrow$ C } 

R2(D,E) {D $\rightarrow$ E} 

R3(A,B,C) { A $\rightarrow$ B, AB $\rightarrow$ C}

All dependency preserved .

R1 And R2 can combine i.e. R1R2( A,C,D, E) and then combine R1R2 and R3(A,B,C) where common attributes(AC) is a key of R3.. so lossless decomposition.

selected by
Answer:

Related questions

189
views
1 answers
1 votes
KISHALAY DAS asked Nov 14, 2016
189 views
1.2k
views
2 answers
2 votes
KISHALAY DAS asked Nov 13, 2016
1,212 views
I have a little doubt regarding the Language L.Any one please what L contain?
276
views
0 answers
3 votes
KISHALAY DAS asked Nov 13, 2016
276 views
Consider the following statements:S1 : Relative mode is the addressing mode which can be used to write code in which reallocation is done at run time.S2 : Indirect ... S1c. Both S1 and S2 are correctd. Neither of S1 or S2 are correct