Question
relation R(ABCD) has these dependencies {A → B, B →
C,C → D} and it is decomposed into three relations R1(AB) , R2(BC), AND R3(CD). State true or false if the decomposition is dependency preserving or not?Solution
The decomposition is dependency preserving. Because the union of all the functional dependencies from R1, R2 AND R3 is equal to the dependencies that are in relation R.
Who among them are studying in class 5?
Which of the following can be coded as ‘sip zdp’?
Who lives to the East of the one who likes Orange?
Who belongs to America?
Which of the following day is off?
Four of the following five are alike in a certain way and hence form a group. Which is the one that does not belong to the group?
Which of the following group represents the tallest and the youngest persons in the group?
How many boxes are there between Y and X?
Which of the following colour is liked by Y?
How many people live on the floors above the one on which Kun-woo lives?