In the three-schema (ANSI/SPARC) architecture, which level describes how a particular group of users sees the data, for example as a view containing only course IDs and enrolment counts?
Correct answer B. External level
Explanation
The three-schema architecture separates the external level (individual user views), the conceptual level (one logical schema of all tables, attributes and constraints) and the internal level (files, indexes and storage details). A view tailored to one user group belongs to the external level. The conceptual level is tempting, but it describes the whole database for the community, not a single user's perspective.
Answer checked How we write and check questions
Discussion