GateAI
ER Model

GATE CSE 2026 Set 2 · Q15

MCQ1 markEasy

Time

In the context of DBMS, consider the two sets T\textbf{T} and S\textbf{S} given below. Which one of the following is the correct match from T\textbf{T} to S\textbf{S} ?

GATE CSE 2026 Set 2 Q15 diagram

Select one answerSingle correct

Pick an option to check

Solution

Step-by-step verified solution

Official answer: C) I-N, II-M, III-L

ER Model

In the standard Three-Schema Architecture of a Database Management System (DBMS):

  1. Logical Schema (Conceptual Level - I): Defines the overall logical structure of the whole database (e.g., tables/entities, attributes, relationships, constraints), which corresponds to Relations (N).

  2. Physical Schema (Internal Level - II): Describes the physical storage structures, access paths, and storage mechanisms used to achieve efficient database performance, which corresponds to File organization and indexes (M).

  3. External Schema (View Level - III): Describes different user views of the database, tailored to specific groups of users, which corresponds to Views (L).

Therefore, the correct mapping is:

I−N,II−M,III−L\text{I} - \text{N},\quad \text{II} - \text{M},\quad \text{III} - \text{L}

Hence, (C) is the correct option.

Try the question first, then check your work.

Think the official key or this write-up is wrong?

Report error or challenge

Examiner trap

The misconception this question tests

This ER Model previous year question is Q15 of the GATE CSE 2026 Set 2 paper. Find more GATE CSE PYQs on ER Model in Databases, or browse all GATE CSE PYQs.

Free diagnostic

Where do you stand for GATE?

Take the 20-minute diagnostic: the 3 topics that cost you the most marks, and a rank range. Or sit 5 related ER Model PYQs now with no account.

One GATE CSE PYQ every morning

An official question by email at 7 AM IST, with a link to its verified solution. Unsubscribe in one click.

ER Model in GATE CSE

ER Model has 8 GATE CSE PYQs across 8 papers from 2012 to 2026. 7 of them are 1-mark MCQs like this one, and it is the only one in GATE CSE 2026 Set 2.

How GATE tests ER Model

More from GATE CSE 2026 Set 2

Share this solution

A plain-text card for WhatsApp or Telegram study groups.

GateAI solution cardGATE CSE 2026 Set 2 · Q15 · MCQ

In the context of DBMS, consider the two sets T and S given below. Which one of the following is the correct match from T to S ?

Topic-wise GATE CS PYQs with verified steps

Independent practice explanation verified by the GateAI team. GATE is conducted by the IITs; question text follows the official paper.