22 min read
What is a Database?
A database is one organised place for related facts — members, books, and loans at a library.
Most organisations keep written facts: names, phone numbers, prices, dates. A school keeps a register. A shop keeps receipts. A hospital keeps patient details.
When those facts belong together, they need one place to live. Not a random pile of files. Not three copies that disagree. One organised home.
Riverside Public Library in York keeps facts about members, books, and loans. A member is not useful on its own if staff cannot later attach a loan. A book title is not useful on its own if staff cannot see who has it out.
Right now those facts sit in separate places: membership cards, a book register, and a loan sheet. They belong together. They do not live together.
| Where the library keeps facts today | ||
|---|---|---|
A database solves that problem. It is one organised collection of related data, stored electronically so staff can find it, change it, and keep it secure.
The database is not the software on the screen. It is the stored facts inside it — the members, the books, the loans — arranged in an agreed structure.
What a database is for
A database has three jobs that matter from day one.
Store related facts in one place. Sophie Walsh's phone should not live on a card, in a notebook, and in a spreadsheet that disagree.
Find facts quickly. When Oliver Bennett needs every member in York, he should not read every card by hand.
Keep facts consistent. When Sophie changes her phone, one update should fix every place that uses it — not three separate edits that might be missed.
| Three jobs of a database | |
|---|---|
A database is not magic. Someone still has to decide what to store and how to organise it. But once that structure exists, the library has one place to trust.
Practice
Swipe or use the arrows to move between questions.
1 / 3
More lessons in Database Fundamentals · Next: Database Management System · Previous: Duplicated Data