← Computer Science syllabus

EnglandComputer Science

3.7 Relational databases and SQL

2 dot points across 2 inquiry questions. Click any dot point for a focused answer with worked past exam questions where available.

How is data organised in a relational database?

Understand relational database concepts including tables, records, fields, primary keys and foreign keys, and why data is organised this way.
A focused answer to AQA GCSE Computer Science 3.7, covering relational database concepts including tables, records, fields, primary keys and foreign keys, and why data is organised this way.
8 min answer →

How do we retrieve and change data in a database using SQL?

Use SQL to retrieve data with SELECT, FROM, WHERE and ORDER BY, and to insert, update and delete records.
A focused answer to AQA GCSE Computer Science 3.7, covering SQL to retrieve data with SELECT, FROM, WHERE and ORDER BY, and to insert, update and delete records.
8 min answer →