Schemas are used in designing database systems.The schema that provides an organization-wide view of the entire database is known as
A)the external-level schema.
B)the internal-level schema.
C)the conceptual-level schema.
D)the logical view of the database.

Question

Quizplus · Accepted Answer

The conceptual-level schema provides an organization-wide view of the entire database. It is also known as the global schema or the enterprise schema. The external-level schema provides a view of the database from the perspective of individual users or groups of users, while the internal-level schema deals with how the data is physically stored and accessed in the database. The logical view of the database is a conceptual representation of the data and relationships among the data.

Schemas Are Used in Designing Database Systems