Grade 8 · Media & Informatics
Explain how a database stores data in tables with records and fields, searched by queries.
When there is a lot of related information to store — all the pupils in a school, all the books in a library — a database keeps it organised. The simplest kind stores data in a table, much like a spreadsheet, with rows and columns.
Each row is a record — all the data about one thing, such as one pupil. Each column is a field — one piece of information that every record has, such as 'surname' or 'class'. Together, the fields describe what is stored and the records hold the actual entries.
The point of a database is to find and update data quickly. You can ask it questions — a query — such as 'show every pupil in class 8B' and get an answer in an instant, even from millions of records. Clear fields and tidy records make those answers reliable.
Have a go right here. Nothing is saved and you can retry as much as you like. Create a free account when you want to save your progress and get Archie, your tutor.
Create a free account to save your progress, track mastery and ask Archie, your tutor, for a hand.
Already with us? Open this lesson in learncoach.ch for mastery tracking and Archie, your tutor.