Databases & relational structure1 / 9
Why use a database?
A database is an organised collection of data. Instead of loose files, a database stores data in structured tables — making it easy to search, update and connect related pieces of information.
Benefits over spreadsheets or files:
- Avoids duplicate data
- Enforces consistency (e.g. date formats)
- Multiple users can access safely
- Security and permissions built in
- Fast searching even with millions of rows