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.

  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…