Conceptual schema

In a database model that supports a three-schema architecture (such as that described by ANSI/X3/SPARC), a description of the information contents and structure of a database. A conceptual schema (also known as a logical schema) provides a model of the total database, thus acting as an intermediary between the two other types of schemas (internal and external) that deal with storing information and presenting it to the user. Schemas are generally defined using commands from a DDL (data definition language) supported by the database system. See also internal schema, schema.