Question 22Asked in UGC NET Computer Science, December 2014 (Paper II & III, Selected Questions)

Identify the minimal key for relational scheme R(A, B, C, D, E) with functional dependencies F = {A → B, B → C, AC → D}

  1. AA
  2. BAE
  3. CBE
  4. DCE
Show answerHide answer

Correct answer: (B) AE

Explanation

{A}⁺ = {A, B, C, D}, which does not include E, so A alone is not a key. {AE}⁺ = {A, B, C, D, E}, and nothing can be removed from AE, so AE is the minimal key.

From UGC NET Computer Science PYQ, December 2014 (Paper II & III, Selected Questions)

This is question 22 of UGC NET Computer Science PYQ, December 2014 (Paper II & III, Selected Questions). See all questions of this paper with answers, or attempt the paper as a timed online test to get your score and all-India rank.