The GATE Grind

GATE Database Management and Warehousing: Integrity constraints and normal forms – Previous Year Questions

6 GATE previous year questions on Integrity constraints and normal forms (Database Management and Warehousing, Data Science and Artificial Intelligence) with answers and explanations, from every paper.

6 questions worth 9 marks in all (3 1-mark, 3 2-mark). Asked between 2024 and 2026, so you can see how the topic has been tested over time.

  1. GATE 2024 DA Q46 (2 marks, Multiple select) – Given the relational schema R = (U, V, W, X, Y, Z) and the set of functional dependencies: \U V, U W, WX Y, WX Z, V X\ Which of the following…
  2. GATE 2025 DA Q16 (1 mark, Multiple choice) – If a relational decomposition is not dependency-preserving, which one of the following relational operators will be executed more frequently in order…
  3. GATE 2025 DA Q56 (2 marks, Multiple select) – Consider the following two relations, named Customer and Person, in a database: Person (aadhaar CHAR(12) PRIMARY KEY, name VARCHAR(32)); Customer…
  4. GATE 2025 DA Q57 (2 marks, Multiple select) – Consider a database relation R with attributes ABCDEFG, and having the following functional dependencies: A BCEF E DG BC A Which of the following…
  5. GATE 2026 DA Q17 (1 mark, Multiple choice) – Let R(A,B,C,D,E) be a relational schema with functional dependency set F = \A BC,\ CD E,\ E A\. Which of the following statements is correct?
  6. GATE 2026 DA Q26 (1 mark, Multiple select) – Consider two relations r and s defined on the relational schemas R(A,B) and S(E,C), respectively. A is the primary key of R and E is a foreign key of…