The GATE Grind

GATE 2026 CS (CS2) – Question 15

Databases · ER-Model and Database Architecture · 1 mark · Multiple choice

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 organization and indexes
$N$: Relations

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

  1. I-L, II-M, III-N
  2. I-M, II-L, III-N
  3. I-N, II-M, III-L
  4. I-N, II-L, III-M

Practise this question in The GATE Grind →

Show answer and explanation

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

Explanation

A logical schema describes the relations in the database, so $I \to N$. A physical schema concerns how data is stored, including file organization and indexes, so $II \to M$. An external schema corresponds to user views, so $III \to L$. Therefore, option (C) is correct.