Question 159

A relation is in BCNF if, for every non-trivial FD X → Y:

  1. AX is a super key
  2. BX is a foreign key
  3. CY is a candidate key
  4. DY is a prime attribute
Show answerHide answer

Correct answer: (A) X is a super key

Explanation

Every determinant must be a (super/candidate) key.

From DSSSB TGT Computer Science Full Mock Test 2

This is question 159 of DSSSB TGT Computer Science Full Mock Test 2. 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.