Databases — Computing, 11–13 years
How organised records let a computer store, update and find information. Computing, 11–13 years.
An organised cupboard of facts
A database is a carefully organised collection of information that a program can read and change. Instead of a loose pile of facts, it uses records with fields, such as one pupil’s name, class and library books. Organisation lets the computer find one record without mixing it up with another.
The problem of repeated facts
Writing the same information separately in many places causes mistakes: a changed address may be updated in one list but forgotten in another. Databases keep related facts together and allow a program to update them consistently. They grew from the need to manage more records than people could safely organise by hand.
Finding books in a library
A library record has Title, Author and Available. A search asks for Author = “Ursula Le Guin”. The program checks that field, keeps the matching records, and then displays their titles and availability. If one book is borrowed, the program changes Available from “yes” to “no”, so the next search shows the current answer.
A database is not magic truth
It is tempting to trust a neat table because organised information looks official. But a database only stores what someone entered, and an old or misspelled value can still be wrong. A good system checks entries, records changes and shows when information was last updated; organisation improves data, but does not guarantee truth.
Services that remember
Online shops use databases for products, prices, stock and orders. Hospitals, transport systems and sports apps use them for different kinds of records too. Whenever a service remembers your settings or shows a result tailored to a search, a database may be organising the information behind the screen.
Keep exploring
Other languages
Loading MyLeoNes™…