GATE | GATE-CS-2016 (Set 1) | Question 31

Which of the following is NOT a superkey in a relational schema with attributes V, W, X, Y, Z and primary key V Y ?

(A) V X Y Z
(B) V W X Z
(C) V W X Y
(D) V W X Y Z


Answer: (B)

Explanation: Super key = Candidate Key + other attributes. But option B does not include Y which is a part of PK or candidate key.


Quiz of this Question



My Personal Notes arrow_drop_up