Key term
AQA GCSE Computer Science 8525
Algorithms
Programming
Data Representation
Topic overviewNumber bases and why hexadecimal is usedConverting between binary, decimal and hexadecimalUnits of information: bits, bytes and prefixesBinary addition and binary shiftsCharacter encoding: ASCII and UnicodePixels, bitmaps and colour depthBitmap image file size calculationsDigital sound: sampling rate and sample resolutionData compression: Huffman coding and run-length encoding
Computer Systems
Computer Networks
Cyber Security
Relational Databases and SQL
Ethical, Legal and Environmental Impacts of Digital Technology
Relational Databases and SQL
- 3 subtopics
- 9 things to know
- Paper 2
What Relational Databases and SQL covers
Relational Databases and SQL is examined in Paper 2, Computing concepts. It covers relational databases and keys, SQL SELECT queries and SQL INSERT, UPDATE and DELETE.
Where it is assessed
Paper 2
Computing concepts, a 1 hour 45 minute paper worth 50% of the GCSE.
Check the AQA specification ↗The 3 subtopics
Each one has its own page.
- Relational databases and keysDatabases, tables, records, fields and data types, primary and foreign keys, linked tables, and how a relational design removes data redundancy and inconsistency.Open →
- SQL SELECT queriesSELECT, FROM, WHERE and ORDER BY with ascending and descending sorts, worked queries on small tables, text in quotation marks, and queries that join two linked tables.Open →
- SQL INSERT, UPDATE and DELETEAdding records with INSERT INTO, changing them with UPDATE and SET, removing them with DELETE FROM, worked commands on small tables, and the danger of a missing WHERE clause.Open →
What you need to know
Answer each one before you reveal it.
Your recallNot started
Key term
What is a database, and what makes one relational?
Key term
How is a database table organised into rows?
Key term
What does an INSERT INTO command do in SQL?
Key term
What does SQL stand for, and what is it used for?
Key term
A table Pupil has fields PupilID, Name and Form. What does INSERT INTO Pupil (PupilID, Name, Form) VALUES (27, 'Amir Khan', '10B') do?
Key term
What is a database?
Key term
What does the SELECT part of an SQL query do?
Key term
Why must the values in an INSERT INTO command be in the same order as the listed fields?
Take Relational Databases and SQL further
The same content, four other ways.
Commonly confused
Pairs that lose marks when they are blurred together.
Primary key vs Foreign key
Primary key: a field whose value uniquely identifies each record in its own table. Foreign key: a field that links to the unique identifier of a record in another table.
Record vs Field
Record: one row of a table holding all the data about one item. Field: one column of a table holding one kind of data for every item.
Data redundancy vs Data inconsistency
Data redundancy: the same facts being stored more than once without need. Data inconsistency: copies of the same facts that no longer match each other.
Questions from this topic
Each one with the model answer underneath.
- 1
What is a database?
Model answer
A database is an organised, persistent collection of data. The data is stored so that it can be searched, sorted and updated easily.
- 2
What is a relational database?
Model answer
A relational database stores data in several separate tables that are linked together. The links are made through fields the tables share.
- 3
What is a table in a database?
Model answer
A table holds the data about one kind of thing, such as students or books. A table is made up of rows and columns.
- 4
What is a record in a database table?
Model answer
A record is one row of a table. A record holds all the data about a single item, such as one student.
- 5
What is a field in a database table?
Model answer
A field is one column of a table. A field holds one piece of data about every record, such as each student's surname.
- 6
What is a data type in a database?
Model answer
A data type sets what kind of value a field can hold. Common data types are integer, real, text, Boolean and date/time.
What is inside Levo
Six ways to work the same material.
Relational Databases and SQL revision questions
- What does Relational Databases and SQL cover in AQA GCSE Computer Science?
- 3 subtopics: relational databases and keys, sql select queries and sql insert, update and delete. Each one has its own page with questions and model answers.
- How is Relational Databases and SQL organised?
- By the AQA 8525 specification, subtopic by subtopic, so it matches the order you are taught it in.
Every question in Relational Databases and SQL, on a schedule.
Attempt a question from memory, write the correct version, then attempt it again. Levo records the jump between your first attempt and your last, and brings each question back on the day you are due to forget it.
Or £46 a year, about £3.83 a month. Cancel anytime.