Skip to content
BENIBIX Learn

Relational Database

Development🗃️ DatabasesRelational Databases

Also known as RDBMS, SQL Database, Relational Database Management System

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

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.

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.

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.

Common mistake

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

Key takeaways

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

Compare