📢 Too many exams? Don’t know which one suits you best? Book Your Free Expert 👉 call Now!

  • google app store apple app store
  • ✖

      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
      ask-question