Skip to content
Related Articles

Related Articles

ISRO | ISRO CS 2014 | Question 42
  • Last Updated : 17 Apr, 2018

Let x, y, z, a, b, c be the attributes of an entity set E. If {x}, {x,y}, {a,b}, {a,b,c}, {x,y,z} are superkeys then which of the following are the candidate keys?

(A) {x,y} and {a,b}
(B) {x} and {a,b}
(C) {x,y,z} and {a,b,c}
(D) {z} and {c}


Answer: (B)

Explanation: A Candidate key is the minimal Superkey i.e. it is a minimal set of attributes required to identify a tuple. {x} ; {a,b} are the candidate keys for the above schema as they do not contain any extraneous attribute.
So, option (B) is correct.

Quiz of this Question

My Personal Notes arrow_drop_up
Recommended Articles
Page :