Practice mode DBMS and SQL

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.

Report a problem

Answer checked How we write and check questions

Tip: press A, B, C or D to answer, and N for the next question.

Advertisement

Have a question about this answer?

Your email address will not be published. Required fields are marked *

Links and website addresses are not allowed in comments.