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 ? Shubham Sharma 2 asked May 14, 2017 Shubham Sharma 2 446 views answer comment Share Follow See all 2 Comments See all 2 2 Comments reply sid1221 commented May 14, 2017 reply Follow Share not dependency preserv ? 1 votes 1 votes akash.dinkar12 commented May 14, 2017 reply Follow Share AB --> D is not preserving... 1 votes 1 votes Please log in or register to add a comment.
Best answer 1 votes 1 votes It is not dependency preserving because from individual tables (R1,R2&R2).,we cannot derive AB-->D. Angkit answered May 14, 2017 selected May 15, 2017 by focus _GATE Angkit comment Share Follow See all 0 reply Please log in or register to add a comment.