Loading previous year questions
Databases · Integrity Constraints and Normal Forms
Official IIT answer key · IIT Kharagpur · Audited Aug 2026
GATE CSE 2014 Set 1 Q21 · MCQ · 1 mark
Key concept
No account needed
Sit 5 related Integrity Constraints and Normal FormsPYQs as a guest. We'll score the set and show which traps cost marks — sign in only if you want to save the run.
Topic notes
In GATE, Normal Forms questions test a candidate's ability to identify candidate keys, classify relational schemas into appropriate normal forms (such as 3NF and BCNF), and evaluate decomposition properties (lossless join and dependency preservation). Questions combine normal form verification with decomposition analysis, frequently formatted as multi-select questions (MSQs) requiring rigorous evaluation of all properties across both the original and decomposed relations.
Full Integrity Constraints and Normal Forms guide →All 30 questions on Integrity Constraints and Normal Forms →
Consider the relation scheme R = (E, F, G, H, I, J, K, L, M, N) and the set of functional dependencies \\E, F\ \G\, \F\ \I, J\, \E, H\ \K, L\, \K\ \M\, \L\ \N\\ on R. What is the key for R?
Topic-wise GATE CS PYQs with verified steps
Independent practice explanation verified by the GateAI team. GATE is conducted by the IITs; question text follows the official paper.