ЁЯУв 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