The GATE Grind

GATE Databases: ER-Model and Database Architecture – Previous Year Questions

12 GATE previous year questions on ER-Model and Database Architecture (Databases, Computer Science) with answers and explanations, from every paper.

12 questions worth 16 marks in all (8 1-mark, 4 2-mark). Asked between 2008 and 2026, so you can see how the topic has been tested over time.

  1. GATE 2008 CS Q82 (2 marks, Multiple choice) – For the ER diagram shown, what minimum number of tables represents M, N, P, R1, R2?
  2. GATE 2008 CS Q83 (2 marks, Multiple choice) – For the ER diagram from Q82, which is a correct attribute set for one resulting table?
  3. GATE 2021 CS (CS2) Q16 (1 mark, Multiple choice) – S1: A relation schema can have at most one foreign key. S2: A foreign key in schema R cannot refer to tuples of R itself. Which are true?
  4. GATE 2012 CS Q24 (1 mark, Multiple choice) – For basic ER and relational models, which is incorrect?
  5. GATE 2017 CS (CS2) Q27 (1 mark, Multiple choice) – Entity types A and B are connected by relationship R with no attributes. When can the relation table for R be merged with A’s table?
  6. GATE 2015 CS (CS1) Q48 (2 marks, Numerical answer) – Consider an Entity-Relationship (ER) model in which entity sets E 1 and E 2 are connected by an m : n relationship R 12. E 1 and E 3 are connected by…
  7. GATE 2018 CS Q21 (1 mark, Multiple choice) – In an Entity-Relationship (ER) model, suppose R is a many-to-one relationship from entity set E1 to entity set E2. Assume that E1 and E2 participate…
  8. GATE 2026 CS (CS2) Q15 (1 mark, Multiple choice) – In the context of DBMS, consider the two sets T and S given below. I: Logical schema II: Physical schema III: External schema L: Views M: File…
  9. GATE 2025 CS (CS1) Q47 (2 marks, Multiple select) – Consider a relational schema team(name, city, owner), with functional dependencies \name city,\ name owner\. The relation team is decomposed into two…
  10. GATE 2024 CS (CS2) Q20 (1 mark, Multiple choice) – In the context of owner and weak entity sets in the ER (Entity-Relationship) data model, which one of the following statements is TRUE?
  11. GATE 2024 CS (CS1) Q20 (1 mark, Multiple choice) – Let S be the specification: "Instructors teach courses. Students register for courses. Courses are allocated classrooms. Instructors guide students."…
  12. GATE 2020 CS Q24 (1 mark, Multiple choice) – Which one of the following is used to represent the supporting many-one relationships of a weak entity set in an entity-relationship diagram?