Can you think of examples from daily life where storing and querying data in a database can be helpful?

Question

Accepted Answer

> [!TLDR]
> Almost every organised activity around us stores records and asks questions of them — contacts on a phone, library catalogues, school results, shop inventories, bank accounts, ticket reservations. Each of these is exactly "a table + a query": data kept once, then filtered on demand with something equivalent to a `SELECT ... WHERE ...`.

## Everyday situations that are really "database + query"

| Daily-life situation | What is stored | A question we ask of it (the query) |
|---|---|---|
| Phone contact list | Name, phone number | "All contacts starting with A" |
| School office | Students, marks, attendance | "Who scored above 90 in IP?" |
| Library | Books, authors, availability | "Which books by R.K. Narayan are available?" |
| Kirana shop / e-commerce | Products, price, stock | "Which items are out of stock?" |
| Bank / ATM | Accounts, balances, transactions | "What is my balance? Last 5 transactions?" |
| Railway / airline reservation | Trains, seats, bookings | "Seats free on train 12628 on 15 Aug?" |
| Hospital | Patients, visits, prescriptions | "Full history of patient P-1042" |

In every case the benefit is the same: the data is stored **once, without duplication**, stays consistent, and any question can be answered **instantly by a query** instead of a manual search through registers.

## One example made concrete — the school library

```sql
CREATE TABLE LIBRARY (
    BookID    INT PRIMARY KEY,
    Title     VARCHAR(50),
    Author    VARCHAR(30),
    Available CHAR(1)        -- 'Y' = on shelf, 'N' = issued
);

INSERT INTO LIBRARY VALUES
(1, 'Malgudi Days',        'R.K. Narayan',   'Y'),
(2, 'The Guide',           'R.K. Narayan',   'N'),
(3, 'Wings of Fire',       'A.P.J. Kalam',   'Y'),
(4, 'Godan',               'Premchand',      'Y');
```

The librarian's daily question, as one line of SQL:

```sql
SELECT Title, Author
FROM LIBRARY
WHERE Available = 'Y';
```

| Title | Author | …

Q.Can you think of examples from daily life where storing and querying data in a database can be helpful?

Concept understanding — Database Querying

Database Querying: Asking Questions of a Data Collection

The Precise Meaning

Why It Matters

The Intuition Behind It

A Real-World Example …

Everyday situations that are really "database + query"

One example made concrete — the school library

Daily-life situation	What is stored	A question we ask of it (the query)
Phone contact list	Name, phone number	"All contacts starting with A"
School office	Students, marks, attendance	"Who scored above 90 in IP?"
Library	Books, authors, availability	"Which books by R.K. Narayan are available?"
Kirana shop / e-commerce	Products, price, stock	"Which items are out of stock?"
Bank / ATM	Accounts, balances, transactions	"What is my balance? Last 5 transactions?"
Railway / airline reservation	Trains, seats, bookings	"Seats free on train 12628 on 15 Aug?"
Hospital	Patients, visits, prescriptions	"Full history of patient P-1042"

Q.Can you think of examples from daily life where storing and querying data in a database can be helpful?

Everyday situations that are really "database + query"

One example made concrete — the school library

🎓Unlock everything free for 14 days

Unlock everything free for 14 days