A-Level Computer Science Revision — Relational Databases
Revise Relational Databases for A-Level Computer Science with a topic explanation, worked example and common mistakes. Check the board notes for specification differences.
At a glance
- What StudyVector is
- An exam-practice platform with board-aligned questions, explanations, and adaptive next steps.
- This topic
- Relational Databases in A-Level Computer Science: explanation, examples, and practice links on this page.
- Who it’s for
- Students revising A-Level Computer Science for UK exams.
- Exam boards
- Check your course page and the topic board notes for supported specifications.
- Free plan
- Sign up free to use tutor paths and feedback on your answers. Free access is Free daily revision · No card required. Pricing
- What makes it different
- Syllabus-shaped practice and progress tracking—not generic AI answers.
This page includes a topic explanation and a worked example. Check your course for current practice coverage.
Next in this topic area
Next step: SQL Queries
Continue in the same course — structured practice and explanations on StudyVector.
Go to SQL QueriesTopic explanation
What is Relational Databases?
A relational database is a type of database that stores and provides access to data points that are related to one another. Relational databases are based on the relational model, which is a way of representing data in tables. Each table has a set of columns and rows, and each row represents a single record.
Board notes: Covered by AQA, Edexcel, and OCR. Students should be able to design and create relational databases and to use SQL to query them.
Step-by-step explanationWorked examples
Worked example
A database for a school might have a table for students and a table for courses. The students table would have columns for student ID, name, and address. The courses table would have columns for course ID, name, and teacher. A third table, called enrollments, would be used to link students to courses. This table would have columns for student ID and course ID.
Practise this topic
Start with low-focus cards for Relational Databases, then move into full exam-style practice when you want the heavier session.
Common mistakes
- 1Confusing tables, records, and fields.
- 2Not understanding the concept of a primary key.
- 3Incorrectly defining relationships between tables.
Relational Databases exam questions
Check the available question sets for Relational Databases. Use your course and exam board to confirm which practice is relevant.
Relational Databases exam questionsGet help with Relational Databases
Get a personalised explanation for Relational Databases from the StudyVector tutor. Ask follow-up questions and work through problems with step-by-step support.
Open tutorSave your progress in Relational Databases
Start a free account for low-focus question cards, feedback and Play routes across available topics. Free daily limits apply; no card required.
Continue your revision
A public question for Relational Databases is still being reviewed. Your course page shows the topics currently available for practice.
Continue with Relational Databases
Create a free account to keep your course choice and save your practice progress.
Start free low-focus cardsAlready have an account? Log in
Frequently asked questions
What is a primary key?
A primary key is a column in a table that uniquely identifies each row in the table. For example, in a students table, the student ID would be the primary key.
What is a foreign key?
A foreign key is a column in a table that refers to the primary key of another table. It is used to create a relationship between the two tables. For example, in the enrollments table, the student ID would be a foreign key that refers to the students table.