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.
More ER-Model and Database Architecture questions
GATE 2025 CS (CS1) Q47– Consider a relational schema team(name, city, owner), with functional dependencies \name…
GATE 2024 CS (CS1) Q20– Let S be the specification: "Instructors teach courses. Students register for courses.…
GATE 2024 CS (CS2) Q20– In the context of owner and weak entity sets in the ER (Entity-Relationship) data model,…
GATE 2020 CS Q24– Which one of the following is used to represent the supporting many-one relationships of a…
GATE 2018 CS Q21– In an Entity-Relationship (ER) model, suppose R is a many-to-one relationship from entity…
GATE 2015 CS (CS1) Q48– Consider an Entity-Relationship (ER) model in which entity sets E 1 and E 2 are connected…