Title: Relational Database Author: Kriko Published: May 26, 2023 Last modified: Jul 7, 2026 --- 1. [Home](https://kriko.io/) / 2. [Glossary](https://kriko.io/glossary) / 3. R Letter # Relational Database A **relational database** is a database model in which information is stored in tables consisting of rows and columns, with defined relationships between those tables. A Relational Database Management System, commonly abbreviated as RDBMS, is the software used to create, query, update and manage relational databases. The relational model was introduced through research published by computer scientist Edgar F. Codd in 1970. It later became one of the foundations of modern database management. Information in a relational database is stored within structured tables. Each table generally represents a particular entity, such as a customer, product, employee or order. Each row represents an individual record, while columns describe the attributes of that record. For example, a customer table may include columns for name, telephone number, email address and location, with each row containing information about a separate customer. A **primary key** is generally used to identify each row uniquely. A customer number in a customer table may serve as the primary key that distinguishes one customer from another. Relationships between tables are commonly created through foreign keys. For example, a customer number stored in an order table can connect each order to the relevant customer record. The relational model enables information to be stored systematically and connected meaningfully across separate tables. Customer, order and product information may be stored independently but queried together through their key relationships. This structure can reduce unnecessary [data](https://kriko.io/services/data-analysis-insight) duplication and support more consistent record management. When the model is designed correctly, insert, update and deletion operations can also be managed more reliably. The most widely used query language in relational database management systems is** SQL**. The abbreviation stands for Structured Query Language. SQL can be used to retrieve information, insert new records, update existing values and delete selected data. It can also be used to manage tables, relationships, permissions and [data](https://kriko.io/services/data-analysis-insight) integrity rules. Relational databases are used in finance, e-commerce, healthcare, telecommunications, public services and enterprise resource management. They are particularly suitable for structured information such as customer records, orders, payment transactions, inventory [data](https://kriko.io/services/data-analysis-insight) and employee details. Organisations of different sizes can use these systems according to their operational requirements. MySQL, PostgreSQL, Microsoft SQL Server and Oracle Database are common examples of RDBMS platforms. One of the main advantages of relational database systems is their support for ** [data](https://kriko.io/services/data-analysis-insight) integrity**. Primary keys, foreign keys, [data](https://kriko.io/services/data-analysis-insight) types and constraints can limit the creation of invalid or inconsistent records. Access controls can determine which users are authorised to view or modify particular tables. Backup, transaction management and recovery capabilities can also help reduce the risk of [data](https://kriko.io/services/data-analysis-insight) loss. Relational databases can be expanded by adding new columns, tables and relationships, but significant structural changes must be planned carefully. Major modifications may affect existing applications, queries and reports. Alternative approaches such as NoSQL may be more suitable for highly variable, rapidly changing or unstructured datasets. Database selection should therefore reflect the structure of the [data](https://kriko.io/services/data-analysis-insight), transaction requirements, scalability needs and the overall application design. ## Discover it in the dictionary ### JavaScript (JS) JavaScript, commonly abbreviated as JS, is a popular programming language used to add interaction and dynamic behaviour to web pages. HTML is used to… ### 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… ### Interactive Content Interactive content is a type of content in which users do not remain only as viewers, listeners or readers; instead, they actively participate by… ### Software as a Service Software as a Service, commonly abbreviated as SaaS, is a cloud-based software delivery model in which software is provided to users over the internet… ### Technical SEO Technical SEO refers to the technical optimization work that helps a website be crawled, understood, indexed and experienced more effectively by search engines and… ### Seed Keyword A seed keyword is the basic word or phrase that forms the starting point of keyword research in SEO and content strategy. It describes… ### Data Visualisation Data visualisation is the practice of presenting information through charts, maps, diagrams and other visual formats. It helps users understand complex datasets and identify… ### Buyer Persona A buyer persona, often simply called a persona, is a semi-fictional customer representation that a brand creates to better understand its target audience. The… ### Supply Chain Management Supply Chain Management, commonly abbreviated as SCM, is a management approach that covers the planning, execution and optimisation of the full process from raw… ## 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).