New Click here to Enroll for SIDBI MSME Expert Class by ex-GM, SBI on Nov 24

    Register

    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