446 views
1 votes
1 votes
A relation R(ABCD) with FD set f = {AB ->CD , D -> A } and the decomposition d = { R1(ABC) , R2(AD) , R3(BCD) }

Check whether the following decomposition is dependency preserving or not ?

1 Answer

Best answer
1 votes
1 votes
It is not dependency preserving because from individual tables (R1,R2&R2).,we cannot derive AB-->D.
selected by

Related questions

0 votes
0 votes
1 answer
1
0 votes
0 votes
1 answer
2
night_fury asked Sep 23, 2018
733 views
The below decomposition is lossless or lossy and also dependency preserving or not?
3 votes
3 votes
1 answer
3
mohitbawankar asked Jan 7, 2018
4,182 views
Consider the following relational schema R(ABCDEFG) with FD set {AB → C, BC → A, AC → B, B → D, D → E}. The minimum relations required to decompose R into BCNF ...