GATE Databases: ER-Model and Database Architecture – Previous Year Questions
7 GATE previous year questions on ER-Model and Database Architecture (Databases, Computer Science) with answers and explanations, from every paper.
- GATE 2015 CS 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?