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 main concepts and the main relationships among them. Typically this is a first-cut model, with insufficient detail to build an actual database. This level 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 on describing entities, datatypes, relationships and constraints. A conceptual schema is a map of concepts and their relationships used for databases. This describes the semantics of an organization and represents a series of assertions about its nature. Specifically, it describes the things of significance to an organization (entity classes), about which it is inclined to collect information, and its characteristics (attributes) and the associations between pairs of those things of significance (relationships). Because a conceptual schema represents the semantics of an organization, and not a database design, it may exist on various levels of abstraction. The original ANSI four-schema architecture began with the set of external schemata that each represents one person's view of the world around him or her. These are consolidated into a single conceptual schema that is the superset of all of those external views. A data model can be as concrete as each person's perspective, but this tends to make it inflexible. If that person's world changes, the model must change. Conceptual data models take a more abstract perspective, identifying the fundamental things, of which the things an individual deals with are just examples. The model does allow for what is called inheritance in object oriented terms. The set of instances of an entity class may be subdivided into entity classes in their own right.

About this result
This page is automatically generated and may contain information that is not correct, complete, up-to-date, or relevant to your search query. The same applies to every other page on this website. Please make sure to verify the information with EPFL's official sources.
Related courses (3)
AR-435: UE R: Introduction to BIM (Building Information Modeling)
Cette Unité d'Enseignement explore plus en détails et par la pratique les principes introduits lors du cours d'Introduction au BIM AR-484. Les différentes phases d'un projet sont traitées, avec un acc
CS-423: Distributed information systems
This course introduces the foundations of information retrieval, data mining and knowledge bases, which constitute the foundations of today's Web-based distributed information systems.
ENV-547: Design of SIG
Ce cours traite de la réalisation d'outils SIG et porte sur l'approche méthodologique, l'environnement technologique et institutionnel, le design conceptuel et l'implémentation. La création d'un Web S
Related lectures (20)
Entity-Relationship Model
Introduces the Entity-Relationship model for designing databases with a focus on conceptual and relational aspects.
Heat Transfer Fundamentals
Covers the fundamentals of heat transfer, focusing on radiation, conduction, and convection, including boundary layers and Nusselt number.
Distributed Information Systems: Overview and Models
Covers Distributed Information Systems, key tasks, methods, projects, evaluation, and exam support.
Show more
Related publications (74)

RE:SLAB — a load bearing system for open-ended component reuse in building structures

Corentin Jean Dominique Fivet, Jan Friedrich Georg Brütting, Dario Redaelli, Alex-Manuel Muresan, Edisson Xavier Estrella Arcos

The construction industry plays a major role in the high levels of greenhouse gas emissions, resource consumption, and waste generation observed nowadays. Key to the circular economy, structural component reuse arises as a promising solution to divert cons ...
2024

What is NExT? A new conceptual model for comfort, satisfaction, health, and well-being in buildings

Dusan Licina

Buildings are designed to respond to functional and regulatory needs, providing comfortable conditions to occupants, offering satisfactory environmental settings, minimising health risks, and enhancing individual and collective quality of life. Although th ...
Oxford2024

Overview on the Applicability of the ITER/NPP-Like Technologies to the DEMO Plant Electrical System and Promising Alternatives

Damien Fasel, Zhe Chen, Elena Gaio, Alberto Ferro, Francesco Santoro, Hanwen Zhang

The Plant Electrical System (PES) of the European DEMOnstration fusion power plant (DEMO), presently under conceptual design, shall supply power to the loads and deliver net power to the Power Transmission Grid (PTG). Starting from the available requiremen ...
Piscataway2024
Show more
Related concepts (9)
Database design
Database design is the organization of data according to a database model. The designer determines what data must be stored and how the data elements interrelate. With this information, they can begin to fit the data to the database model. A database management system manages the data accordingly. Database design involves classifying data and identifying interrelationships. This theoretical representation of the data is called an ontology. The ontology is the theory behind the database's design.
Logical schema
A logical data model or logical schema is a data model of a specific problem domain expressed independently of a particular database management product or storage technology (physical data model) but in terms of data structures such as relational tables and columns, object-oriented classes, or XML tags. This is as opposed to a conceptual data model, which describes the semantics of an organization without reference to technology. Logical data models represent the abstract structure of a domain of information.
Database schema
The database schema is the structure of a database described in a formal language supported typically by a relational database management system (RDBMS). The term "schema" refers to the organization of data as a blueprint of how the database is constructed (divided into database tables in the case of relational databases). The formal definition of a database schema is a set of formulas (sentences) called integrity constraints imposed on a database. These integrity constraints ensure compatibility between parts of the schema.
Show more

Graph Chatbot

Chat with Graph Search

Ask any question about EPFL courses, lectures, exercises, research, news, etc. or try the example questions below.

DISCLAIMER: The Graph Chatbot is not programmed to provide explicit or categorical answers to your questions. Rather, it transforms your questions into API requests that are distributed across the various IT services officially administered by EPFL. Its purpose is solely to collect and recommend relevant references to content that you can explore to help you answer your questions.