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 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 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 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 integrity**. Primary keys, foreign keys, data 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 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, transaction requirements, scalability needs and the overall application design. ## Discover it in the dictionary ### Python Python is a high-level programming language created by Guido van Rossum and first released in 1991. Its name was inspired by the British comedy… ### Cascading Style Sheets (CSS) Cascading Style Sheets, commonly abbreviated as CSS, is a style language used to define the visual presentation of web pages. It is one of… ### Open Graph Open Graph, commonly abbreviated as OG, is a metadata protocol used to define how web pages appear on social media platforms and messaging applications.… ### Data Warehouse A data warehouse, commonly abbreviated as DWH, is a data management system that brings information from different sources together for analysis and reporting. Companies… ### URL (Uniform Resource Locator) URL stands for Uniform Resource Locator and refers to the address of a resource on the internet. It can be understood as a standard… ### Cost Per Mille (CPM) CPM, short for Cost Per Mille or Cost Per Thousand Impressions, is a digital advertising metric that shows the average cost of one thousand… ### Secure Sockets Layer (SSL) SSL stands for Secure Sockets Layer. It is an older security protocol that enables an encrypted connection between a browser and a web server.… ### Bounce Rate Bounce Rate is a web analytics metric that shows the percentage of sessions in which users leave a website without creating meaningful engagement. This… ### Prescriptive Analytics Prescriptive analytics is an analytical approach that uses predictive modelling, optimisation methods and advanced algorithms to recommend the most appropriate actions. It does not… ## 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).