That Blue Square Thing

Syllabus content:
PDF iconUnit 7 content – PDF doc to download
Note: this syllabus content is a slightly amended version of the one published freely on the web by AQA. I have made very minor adjustments to remove some content less suitable for students to use and it is presented here simply to allow the children I teach to download a usable copy of the syllabus content. It is copyright AQA and reproduced here simply to make access easier for students. No attempt to claim copyright is being made, although I could have copied the text into my own interpretation...

AQA Computer Science GCSE

This page is up to date for the AQA 8525 syllabus for exams from 2022.

Databases and SQL

Databases are really important in the modern world.

We use data everywhere. And that has to be organised, usually in a database.

Most of the marks here will be for writing database queries, but there are some really important definitions that you need to make sure that you know as well. Don't ignore these sorts of things.

Key points:
PDF iconDefinitions – the key set of terms you need to know
PDF iconKey database ideas – fields and records

Introducing databases

PDF iconDatabase basics - slides from class

PDF iconIntro questions - the terms to define

PDF iconBirds database exam questions

Some examples of databases might be handy.

PDF iconSome real-world examples of databases

PDF iconSome examples of primary keys

More complex databases

Once you've got the idea of simple databases, we can get more complex...

PDF iconMore complex databases - slides from class

PDF iconQuestions

Multi-table (relational) databases

And this brings us to multi-table databases - which are called relational databases.

PDF iconMulti-table databases - slides from class

PDF iconMulti-table questions

More on databases

There's a quite nice introduction to databases on BBC Bitesizewiki link that might be useful