Data modelling - Technology
Relational database
A database that stores information in tables that can be linked to each other
What's it for?
Makes related information easy to connect, search and update without duplicating it everywhere.
For example…
Customer orders and their items are stored in linked tables.
A relational database stores customers in one table and orders in another, linking each order to the customer who placed it
Think of it like…
Well-labelled filing cabinet where folders cross-reference each other