Difficulty: Easy
Correct Answer: subschema
Explanation:
Introduction / Context:
Modern database architectures separate how data is stored from how it is viewed to improve flexibility and security. The ANSI/SPARC three-level model defines external, conceptual, and internal levels. Understanding the correct term for the application-level view helps you reason about permissions, data abstraction, and interface stability as systems evolve.
Given Data / Assumptions:
Concept / Approach:
The subschema represents the external view tailored for a particular program or user group. It includes only the fields and relations required and can rename or restructure them for convenience. The overall logical design is the schema (conceptual level). The subschema shields applications from changes in the underlying schema and from unnecessary exposure of data they do not use.
Step-by-Step Solution:
Verification / Alternative check:
Documentation for DBMS architectures consistently associates the external level with subschemas or external schemas, sometimes realized via views and permissions.
Why Other Options Are Wrong:
Common Pitfalls:
Assuming “schema” equals any view; in ANSI/SPARC terminology, “subschema” is the precise term for the application’s external view.
Final Answer:
subschema
Discussion & Comments