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.
- GATE 2008 CS Q82 – For the ER diagram shown, what minimum number of tables represents M, N, P, R1, R2?
- GATE 2008 CS Q83 – For the ER diagram from Q82, which is a correct attribute set for one resulting table?
- GATE 2021 CS (CS2) Q16 – 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?
- GATE 2012 CS Q24 – For basic ER and relational models, which is incorrect?
- GATE 2017 CS (CS2) Q27 – 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?
- GATE 2015 CS (CS1) Q48 – 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…
- GATE 2018 CS Q21 – 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…
- GATE 2026 CS (CS2) Q15 – 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…
- GATE 2025 CS (CS1) Q47 – Consider a relational schema team(name, city, owner), with functional dependencies \name city,\ name owner\. The relation team is decomposed into two…
- GATE 2024 CS (CS2) Q20 – In the context of owner and weak entity sets in the ER (Entity-Relationship) data model, which one of the following statements is TRUE?
- GATE 2024 CS (CS1) Q20 – Let S be the specification: "Instructors teach courses. Students register for courses. Courses are allocated classrooms. Instructors guide students."…
- GATE 2020 CS Q24 – Which one of the following is used to represent the supporting many-one relationships of a weak entity set in an entity-relationship diagram?