# Relational Database

> A database that keeps data in linked tables. You talk to it in SQL.

**Field:** Software Development  
**Category:** Databases  
**Also known as:** RDBMS, SQL Database, Relational Database Management System

## Think of it like

Think of it like a set of class lists that point to each other. A pupil's number links them all.

## Definition

A relational database keeps data in tables that link to each other through keys. Each table holds one kind of thing, and keys tie a row in one table to rows in another. You ask it questions in SQL. It checks the rules you set, so the data stays correct. PostgreSQL, MySQL and SQLite are all relational databases.

## Example

Jack's shop stores customers, orders and products in three tables. One SQL query joins them to show who bought what.

## Why it matters

Most business data lives in relational databases. They have been the safe default for over 40 years.

## Common mistake

Picking a NoSQL database just because it sounds new. If your data has clear links, tables are usually the better fit.

## Three principles

- **Linked tables.** Keys tie the tables together.
- **Spoken in SQL.** One language for every question.
- **Rules kept.** The database checks each change.

## Related terms

- [Database](https://learn.benibix.com/term/development/database)
- [Structured Query Language (SQL)](https://learn.benibix.com/term/development/sql)
- [Foreign Key](https://learn.benibix.com/term/development/foreign-key)
- [NoSQL Database](https://learn.benibix.com/term/development/nosql-database)
- [Microsoft SQL Server](https://learn.benibix.com/term/development/sql-server)

## Told apart from

- [SQL vs NoSQL](https://learn.benibix.com/compare/sql-vs-nosql): A SQL database keeps data in linked tables with fixed rules. A NoSQL one uses other shapes, like documents or keys, and has looser rules.

---

Source: https://learn.benibix.com/term/development/relational-database
Author: Behnia Zarei (a developer in Vienna, Austria, who builds and teaches data, AI and business intelligence at BENIBIX)
Publisher: BENIBIX Learn (https://learn.benibix.com/)
Last updated: 2026-11-19
Licence: CC BY 4.0 (https://creativecommons.org/licenses/by/4.0/). Quote freely with attribution.
