๐Ÿ“ข Too many exams? Donโ€™t know which one suits you best? Book Your Free Expert ๐Ÿ‘‰ call Now!

  • google app store apple app store
  • โœ–

      Question

      Given a relation R(A, B, C, D, E) and functional

      dependencies {A -> B, BC -> D, D -> E}. Which of the following is a candidate key for R?
      A A Correct Answer Incorrect Answer
      B AC Correct Answer Incorrect Answer
      C BC Correct Answer Incorrect Answer
      D AD Correct Answer Incorrect Answer
      E BD Correct Answer Incorrect Answer

      Solution

      (AC)+ = A, C, B (from A->B), D (from BC->D), E (from D->E). So (AC)+ = {A, B, C, D, E}. No proper subset of AC can determine all attributes.

      Practice Next
      ask-question