632 views

1 Answer

0 votes
0 votes
In Normalisation , whenever we decomposed The relation we need to have a attribute common in both relation and that attribute should serve as CK for any one of the relation .-- to have LOSSLESS DECOMPOSITION

They have decomposed into R1 ( ABC ) and R2( D,E) ---Since no common attribute Therefore it is lossy decomposition .

And it is neither dependency preserving also .

hence option d

Related questions

0 votes
0 votes
1 answer
2
phaniphani asked Nov 16, 2023
176 views
is it allowed in a B+ tree, while deletion to leave behind a key in internal nodes while deleting it from the leaf ?