πŸ“’ Too many exams? Don’t know which one suits you best? Book Your Free Expert πŸ‘‰ call Now!


    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?
    A True Correct Answer Incorrect Answer
    B False Correct Answer Incorrect Answer
    C none of these Correct Answer Incorrect Answer

    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.

    Practice Next
    More IT Networking Questions
    ask-question