Conceptual schema

A conceptual schema or conceptual data model is a high-level description of informational needs underlying the design of a database.

Uses your system voice; voice and rate in settings.

≈ 2 min read

Cite, export and learn8 citation formats · 8 exports · lesson and quiz

Names in other languages

No names in other languages are held for this entry yet.

Article bodies are English and are not machine-translated. A name in another language is not a translation of the article.

A conceptual schema or conceptual data model is a high-level description of informational needs underlying the design of a database. It typically includes only the core concepts and the main relationships among them. This is a high-level model with insufficient detail to build a complete, functional database.

It describes the structure of the whole database for a group of users. The conceptual model is also known as the data model that can be used to describe the conceptual schema when a database system is implemented. It hides the internal details of physical storage and targets the description of entities, datatypes, relationships and constraints.

Example relationships

Each person may be the vendor in one or more orders. Each order must be one and only one person. "Person" is a subtype of "party".

(Meaning that every instance of 'person' is also an instance of 'party'.) Each employee may have a supervisor who is also an employee.

A different point of view, as described by the agile community

Text derived from https://en.wikipedia.org/w/index.php?oldid=1347125504 under CC BY-SA 4.0; modifications have been made.

Provenance

snapshot enwiki-001347125504 · captured 2026-04-04 · ledger · version history

Cite this page as: encyclopegia.org, “Conceptual schema”, snapshot enwiki-001347125504. https://encyclopegia.org/a/conceptual-schema

Sources cited in this revision

No external citation was extracted for this revision. That is a statement about the source, not a claim that none exists.