A relational database stores structured information in tables connected by relationships and queried with SQL.
Tables, keys, and relationships
Relational systems organize records into tables. Primary keys identify rows, while foreign keys connect related records such as customers, orders, and payments.
The strength of structure
SQL joins let an application answer questions across tables without duplicating every fact. Constraints and transactions also help keep connected records accurate when several changes happen together.