Which of the following is NOT a superkey in a relational schema with attributes V, W, X, Y, Z and primary key V Y?
Topic-wise GATE CS PYQs with verified steps
GATE CSE 2016 Set 1 · Q21
Time
Select one answerSingle correct
Solution
Official answer: B) V W X Z
Integrity Constraints and Normal FormsA superkey is any superset of a candidate key (or primary key).
Here, the primary key is . Therefore, any set of attributes containing both and is a valid superkey:
Option A: contains both and , so it is a superkey.
Option B: does not contain attribute , so it cannot be a superkey.
Option C: contains both and , so it is a superkey.
Option D: contains both and , so it is a superkey.
Thus, option B is NOT a superkey.
Try the question first, then check your work.
Examiner trap
A superkey must contain all attributes of a candidate/primary key as a subset.
This Integrity Constraints and Normal Forms previous year question is Q21 of the GATE CSE 2016 Set 1 paper. Find more GATE CSE PYQs on Integrity Constraints and Normal Forms in Databases, or browse all GATE CSE PYQs.
Free diagnostic
Take the 20-minute diagnostic: the 3 topics that cost you the most marks, and a rank range. Or sit 5 related Integrity Constraints and Normal Forms PYQs now with no account.
An official question by email at 7 AM IST, with a link to its verified solution. Unsubscribe in one click.
Integrity Constraints and Normal Forms has 30 GATE CSE PYQs across 20 papers from 2011 to 2026. 10 of them are 1-mark MCQs like this one, and GATE CSE 2016 Set 1 has 2.
How GATE tests Integrity Constraints and Normal FormsIndependent practice explanation verified by the GateAI team. GATE is conducted by the IITs; question text follows the official paper.