chapter

Relational Model, ER Design and Schema Architecture PYQs for GATE CS

Solve 6+ Relational Model, ER Design and Schema Architecture previous year questions for GATE CS with answers and detailed solutions. Free sample questions be

Try a question

Answer it here to see how it works. Nothing is recorded until you sign in.

Question 1

2026 Slot Set2 PYQ

In the context of DBMS, consider the two sets T and S given below. T S I: Logical schema L: Views II: Physical schema M: File organization and indexes III: External schema N: Relations Which one of the following is the correct match from T to S ?

Question 2

2024 Slot Set2 PYQ

In the context of owner and weak entity sets in the ER (Entity-Relationship) data model, which one of the following statements is TRUE?

Question 3

2024 Slot Set1 PYQ

Let S be the specification: "Instructors teach courses. Students register for courses. Courses are allocated classrooms. Instructors guide students." Which one of the following ER diagrams CORRECTLY represents S? Instructor Teaches Course Registration Classroom Allocation Student Guides (i) Instructor Teaches Course Classroom Allocation Registration Projects Guides (ii) Instructor Teaches Course Classroom Allocation Registration Student Guides (iii) Instructor Teaches Course Classroom Allocation Registration Student Guides (iv)

Question 4

2023 PYQ

Which one of the options given below refers to the degree (or arity) of a relation in relational database systems?

Question 5

2023 PYQ

Consider the following table named Student in a relational database. The primary key of this table is rollNum. Student rollNum name gender marks 1 Naman M 622 Aliya F 703 Aliya F 804 James M 825 Swati F 65 The SQL query below is executed on this database. SELECT * FROM Student WHERE gender = ‘F’ AND marks > 65; The number of rows returned by the query is __________.

Question 6

2021 Slot Set2 PYQ

Consider the following statements S1 and S2 about the relational data model: S1: A relation scheme can have at most one foreign key. S2: A foreign key in a relation scheme R cannot be used to refer to tuples of R. Which one of the following choices is correct?

Free preview ends here

Login to view the complete previous-year questions and solutions

Creating an account is free. You get the rest of this chapter, step-by-step solutions, and a study plan built around the topics you are actually weak at.

Why MastersUp

Personalised first. High quality throughout.

Most platforms hand everyone the same content. Here the content moves with your performance, topic by topic.

Built around you, not around a syllabus PDF

Every answer you give moves your topic-level intelligence rate. The next question, the next revision card and tomorrow's plan all change with it.

Revision that hits your weak spots

We only revise topics you have actually attempted and are still below the safe bar on — never the same chapter on repeat.

Questions calibrated to the real exam

Each question carries a measured toughness. You are served a rung above your current level, so practice keeps stretching you.

Notes written for recall, not for volume

Full lesson cards for first study, curated short-note cards for the last mile — with derivations, traps and exam patterns marked.

One place for everything

Notes, chapter practice, previous-year questions, test series and full-length papers — all feeding one picture of your preparation.

Honest progress

No vanity streaks. Progress here means chapters mastered and accuracy that held up on harder questions.

Unlock the whole course

Full notes and short notes, the complete question bank with worked solutions, mock tests, full-length papers, and an adaptive plan that rebuilds itself as you improve.

View all plans Start free

Relational Model, ER Design and Schema Architecture PYQs for GATE CS

Solve 6+ Relational Model, ER Design and Schema Architecture previous year questions for GATE CS with answers and detailed solutions. Free sample questions below.

Chapter Roadmap: Relational Model, ER Design and Schema Architecture

Chapter Journey

ER Modeling & Weak Entities

Design databases visually • Foundational topic

Master: Entity types, cardinalities, weak vs strong entities

Relational Schemas & Keys

Convert ER to tables • High importance

Master: Primary/Foreign keys, referential integrity

Three-Schema Architecture

Abstraction layers • Moderate importance

Master: External, conceptual, internal schemas

What You Will Achieve

Translate real-world requirements into professional ER diagrams
Identify and correctly model weak entities and their owners
Convert any ER diagram into normalized relational schemas

Topic Hero: The Foundation of ER Modeling

The Core Mental Model

Database design begins with a conceptual blueprint, independent of any specific software. This blueprint is the Entity-Relationship model.

1. Entities

The independent nouns. (e.g., Student, Course)

2. Relationships

The verbs connecting them, governed by cardinality rules. (e.g., Enrolls, Teaches)

3. Weak Entities

The dependent nouns that rely on an owner for their very identity. (e.g., Loan dependent on Branch)

Key Principle

Ask: "Does this thing exist independently and have its own unique identity?" If yes, it is an entity. If it only exists as a property of something else, it is an attribute.

Valid: Student is an entity (exists independently).

Invalid: Name is an entity (it is just an attribute).

Relational Model, ER Design and Schema Architecture: Solved Questions with Step-by-Step Explanations (6 Problems)

Question 1 · Databases · 2026_Set2 MCQ

In the context of DBMS, consider the two sets T and S given below.

T	S
I: Logical schema	L: Views
II: Physical schema	M: File organization and indexes
III: External schema	N: Relations

Which one of the following is the correct match from T to S ?

A.
I – L, II – M, III – N
B.
I – M, II – L, III – N
C.
I – N, II – M, III – L
D.
I – N, II – L, III – M

Question 2 · Databases · 2024_Set2 MCQ

In the context of owner and weak entity sets in the ER (Entity-Relationship) data model, which one of the following statements is TRUE?

A.
The weak entity set MUST have total participation in the identifying relationship
B.
The owner entity set MUST have total participation in the identifying relationship
C.
Both weak and owner entity sets MUST have total participation in the identifying relationship
D.
Neither weak entity set nor owner entity set MUST have total participation in the identifying relationship

Question 3 · Databases · 2024_Set1 MCQ

Let S be the specification: "Instructors teach courses. Students register for courses. Courses are allocated classrooms. Instructors guide students." Which one of the following ER diagrams CORRECTLY represents S?

A.
(i)
B.
(ii)
C.
(iii)
D.
(iv)

Question 4 · Databases · 2023 MCQ

Which one of the options given below refers to the degree (or arity) of a relation in relational database systems?

A.
Number of attributes of its relation schema.
B.
Number of tuples stored in the relation.
C.
Number of entries in the relation.
D.
Number of distinct domains of its relation schema.

Question 5 · Databases · 2023 NAT

Consider the following table named Student in a relational database. The primary key of this table is rollNum.

Student

The SQL query below is executed on this database.

SELECT *
FROM Student
WHERE gender = ‘F’ AND
marks > 65;

The number of rows returned by the query is __________.

Question 6 · Databases · 2021_Set2 MCQ

Consider the following statements S1 and S2 about the relational data model:

S1: A relation scheme can have at most one foreign key.
S2: A foreign key in a relation scheme R cannot be used to refer to tuples of R.

Which one of the following choices is correct?

A.
Both S1 and S2 are true.
B.
S1 is true and S2 is false.
C.
S1 is false and S2 is true.
D.
Both S1 and S2 are false.

Try a question

Login to view the complete previous-year questions and solutions

Personalised first. High quality throughout.

Built around you, not around a syllabus PDF

Revision that hits your weak spots

Questions calibrated to the real exam

Notes written for recall, not for volume

One place for everything

Honest progress

Unlock the whole course

Relational Model, ER Design and Schema Architecture PYQs for GATE CS

Chapter Roadmap: Relational Model, ER Design and Schema Architecture

Chapter Journey

Topic Hero: The Foundation of ER Modeling

The Core Mental Model

Relational Model, ER Design and Schema Architecture: Solved Questions with Step-by-Step Explanations (6 Problems)

More previous year questions (pyqs) in this unit