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
GATE CSE 2026 Set 2 · Q15
Time

Select one answerSingle correct
Solution
Official answer: C) I-N, II-M, III-L
ER ModelIn the standard Three-Schema Architecture of a Database Management System (DBMS):
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).
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).
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:
Hence, (C) is the correct option.
Try the question first, then check your work.
Examiner trap
Recall the three levels of DBMS architecture: the internal/physical level deals with storage and indexing, the conceptual/logical level deals with tables (relations), and the external level provides user-specific views.
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
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.
An official question by email at 7 AM IST, with a link to its verified solution. Unsubscribe in one click.
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 ModelIndependent practice explanation verified by the GateAI team. GATE is conducted by the IITs; question text follows the official paper.