Skip to content
Related Articles

Related Articles

Improve Article
Save Article
Like Article

ISRO | ISRO CS 2007 | Question 54

  • Difficulty Level : Basic
  • Last Updated : 22 Apr, 2020

BCNF is not used for cases where a relation has
(A) Two (or more) candidate keys
(B) Two candidate keys and composite
(C) The candidate key overlap
(D) Two mutually exclusive foreign keys

Answer: (D)

Explanation: A relation is in BCNF if all attributes which are determinants are also candidate keys in every relation.
Transformation into BCNF deals with the problem of overlapping keys and there is no problem with two or more CK.

Option (D) is correct.

Quiz of this Question

My Personal Notes arrow_drop_up
Recommended Articles
Page :

Start Your Coding Journey Now!