Title: Data Modelling Author: Kriko Published: May 30, 2023 Last modified: Jul 7, 2026 --- 1. [Home](https://kriko.io/) / 2. [Glossary](https://kriko.io/glossary) / 3. D Letter # Data Modelling **Data modelling** is the process of creating models that define an organisation’s data, the relationships between different data elements and the way information will be stored. Business requirements, data structures and database designs are represented through visual diagrams and technical definitions. Data modelling enables organisations to explain systematically what information they collect, what it represents and how different data elements are connected. Entities such as customers, products, orders, employees and suppliers can be defined together with their relevant attributes. Relationships between these entities are also represented according to specific business rules. This makes complex data structures easier to understand, manage and maintain. Data models may use diagrams to represent tables, fields, entities and relationships. These visual structures help business and technical teams develop a shared understanding of data requirements. Professionals responsible for this work may be described as data modellers, data architects or database designers. Their role is not limited to creating visual designs, as they must also translate business requirements into accurate and practical data structures. Data modelling makes it easier for an organisation to document the information it holds and the ways in which that information is used. A well-designed model can improve communication between business teams and information technology departments. It can support **data consistency** by preventing the same concept from being defined differently across multiple systems. It may also help identify duplicate records, missing relationships and unsuitable data structures before development begins. The data modelling process is generally divided into three main levels: **conceptual, logical and physical data models**. These models represent the same system at different levels of detail. The conceptual model focuses on business requirements, the logical model defines the structure of the data, and the physical model addresses technical implementation. Each stage provides a foundation for the next level of design. A **conceptual data model** presents the main business concepts and the general relationships between them. It does not include detailed database or technology specifications. For example, customer, product and order may be defined as the main entities. The model may also show that a customer can place an order and that an order can include one or more products. A **logical data model** transforms the entities identified in the conceptual model into a more detailed data structure. It defines entity attributes, unique identifiers and the rules governing relationships. For example, a customer entity may contain a customer number, name, contact details and membership date. The logical model remains independent of a specific database technology and describes how the information should be organised. A **physical data model** defines how the logical model will be implemented within a specific database management system. It includes table and column names, data types, primary and foreign keys, indexes, constraints and storage details. For example, a customer number may be created as an integer primary key, while a foreign key in the order table may link each order to the relevant customer. The physical model therefore represents the level closest to the actual technical database design. A relationship described as “a customer purchases a product” in the conceptual model may be expanded into customer, order and product entities in the logical model. In the physical model, this structure is implemented through actual tables, fields and key relationships. The process therefore moves systematically from a general business requirement to a working database design. This approach helps ensure that the final database meets both business needs and technical performance requirements. In summary, data modelling defines not only how information will be stored but also what it means and how different data elements are connected. A well-prepared data model can accelerate database development and reduce structural problems that may otherwise emerge later. It also provides a more reliable foundation for reporting, analytics, integration and data governance activities. Data modelling is therefore considered one of the core stages of modern data management. ## Discover it in the dictionary ### Data Architecture Data architecture is the structure that defines how an organisation collects, stores, manages, integrates and uses data. It brings data systems, technologies, rules, standards… ### Rich Snippet A rich snippet is an enhanced search result that displays additional information alongside the standard title, URL and description. To understand this concept clearly,… ### Cost Per Action / Cost Per Acquisition Cost Per Action or Cost Per Acquisition, commonly abbreviated as CPA, is a digital marketing metric that shows the average cost of generating a… ### Content Delivery Network (CDN) A Content Delivery Network, commonly abbreviated as CDN, is a distributed server network that helps deliver website content to users faster, more securely and… ### Master Data Management (MDM) Master Data Management, commonly abbreviated as MDM, is an approach used to define and manage an organisation’s core business data according to shared rules.… ### Data Science Data science is an interdisciplinary field that aims to extract meaningful, usable and actionable insights from data. Smartphones, social media applications, e-commerce websites, online… ### Nofollow Link A nofollow link is a link attribute that helps search engines evaluate the relationship between one website and another linked page. It is used… ### Data Cleansing Data cleansing, also known as data cleaning, is the process of identifying and correcting inaccurate, incomplete, irrelevant, duplicated or inconsistent information within a database.… ### Frequently Asked Questions (FAQ) Frequently Asked Questions, commonly abbreviated as FAQ, refers to a content section where the most common questions about a product, service, process or website… ## Track the digital heartbeat with Kriko Subscribe to receive curated insights, news, and ideas shaping the digital landscape. By checking this box, you acknowledge and accept our [privacy policy](https://kriko.io/privacy-policy).