A database is an organised collection of data, stored so that it can be quickly searched, sorted and updated. Unlike a list of facts jotted in a notebook, a database has a defined structure that lets software find exactly the information it needs within milliseconds — even across millions of records.

Why do we need databases?

Think about a school. It needs to store data about hundreds of students, dozens of subjects, thousands of lessons, and thousands of grades. A spreadsheet with all of this crammed onto one sheet would become unmanageable almost immediately — the same student name would appear in hundreds of rows, and correcting a single spelling mistake would mean hunting through the entire file.

A database solves this by organising data into related tables and linking them logically, so each piece of information is stored only once. The DfE national curriculum for computing asks KS3 students to "collect, organise and create information relevant to a task" — databases are the professional way to do exactly that.

What is a table, record and field?

These three terms are the building blocks of every database:

Term Definition Real-world analogy
Table A collection of related data, arranged in rows and columns A single sheet within a filing cabinet folder
Record One row in a table — all the information about one item or person A single form about one student
Field One column in a table — a single category of data The "Date of Birth" box on the form

Example: a Students table

StudentID FirstName LastName Year TutorGroup
001 Amara Osei 8 8A
002 Jack Patel 9 9C
003 Lily Chen 7 7B
  • The table is called Students.
  • Each row (e.g. row 1 — Amara Osei) is a record.
  • Each column (e.g. FirstName, Year) is a field.
  • StudentID is the primary key — a unique identifier that distinguishes every record. No two students share the same ID.

What is a primary key?

A primary key is a field (or combination of fields) whose value is unique for every record in the table. It prevents duplicates and allows one table to link to another.

In the Students table above, StudentID is the primary key. Even if two students are called "Jack Patel," they will have different IDs, so the database can always tell them apart.

What is a relational database?

A relational database stores data across multiple tables and links them using keys. This avoids repeating the same data in multiple places.

Example: Students and Grades

GradeID StudentID Subject Grade
G001 001 Maths 7
G002 001 English 6
G003 002 Maths 8

The Grades table uses StudentID as a foreign key to refer back to the Students table. To find Amara's grades, the database looks for all rows in Grades where StudentID = 001 — without repeating Amara's name, year group or tutor in the Grades table. Data is stored once and referenced everywhere it is needed.

What is a query?

A query is a question you put to the database. Most databases use SQL (Structured Query Language) for this, though KS3 tools like Microsoft Access also provide graphical query builders.

A typical SQL query:

SELECT FirstName, LastName
FROM Students
WHERE Year = 8
ORDER BY LastName;

This reads: "Show me the first and last name of every student in Year 8, sorted alphabetically by last name."

The four most important SQL keywords at KS3 are:

Keyword Purpose
SELECT Choose which fields to display
FROM Specify which table to query
WHERE Filter records by a condition
ORDER BY Sort the results

How is a database different from a spreadsheet?

Both spreadsheets and databases can store tabular data, but they suit different tasks:

Feature Spreadsheet Database
Best for Small, single-table data; calculations Large, multi-table data; relationships
Duplicate control Relies on the user Enforced by primary/foreign keys
Query power Limited filtering Powerful SQL queries across tables
Multiple users at once Difficult Designed for concurrent access
Scale Thousands of rows (practical limit) Millions or billions of rows

Spreadsheets are excellent for analysing a class's test scores. A database is the right choice for storing a school's entire roll, timetable, and attendance history.

Frequently asked questions

What is a database in simple terms for KS3?

A database is an organised store of data that can be searched, sorted and updated quickly. It arranges data into tables (rows and columns), where each row is a record about one thing (e.g. one student) and each column is one type of information (e.g. surname). Databases are used everywhere — from school roll systems to streaming services that remember what you have watched.

What is the difference between a field and a record?

A record is an entire row in a table — all the information about one person or item. A field is one column — a single category of data. In a Contacts table, one record is everything about one contact; the "Phone Number" field is that one category across all contacts.

What does SQL stand for and do I need to learn it at KS3?

SQL stands for Structured Query Language. At KS3, students typically meet simple SELECT … FROM … WHERE queries rather than the full language. Understanding what a query does — filtering and retrieving specific data from a table — is the key learning objective. The exact syntax is studied in more depth at GCSE.

Why do databases use primary keys?

A primary key gives every record a unique identifier, preventing two records from being confused even if other fields (like name) are identical. It also allows tables to be linked — a grade record can reference a student by their ID rather than copying all their details, which keeps the database consistent and efficient.

For Socratic computing tutoring — from databases to Python — see aitutors.me.