AQA GCSE Computer Science (8525)

3.7: Relational Databases and Structured Query Language (SQL): revision quiz and key terms

Free practice for 3.7: Relational Databases and Structured Query Language (SQL) in AQA GCSE Computer Science (8525). It has 2 parts: 3.7.1 Relational Databases and 3.7.2 Structured Query Language (SQL). Try the questions, then check the key terms.

Try 5 free questions

No sign-in needed. Tap an answer to check it.

Question 1 · Multiple choice

A 'Customers' table and an 'Orders' table are linked using a customer ID field that appears in both. What is this ID likely to be in the Orders table?

Question 2 · True or false?

INSERT INTO is used to add a new record into a table.

Question 3 · Multiple choice

What is a record, in the context of a database?

Question 4 · True or false?

WHERE is used to sort the results of a query.

Question 5 · Multiple choice

Which keyword is used in an UPDATE statement to specify a column's new value?

In RADevo, this topic has fill-in-the-blank, matching, multiple-choice and true or false activities, and every question you get wrong comes back in Revise today until you've learnt it.

Key terms for 3.7: Relational Databases and Structured Query Language (SQL)

Attribute: An alternative term for a field, used in abstract database models.
Data inconsistency: A problem where the same data appears in conflicting versions across a database.
Data type: The kind of value a field is designed to store, such as text or numbers.
Foreign key: A field in one table that is the primary key of another table, used to link the two tables.
INSERT INTO: The SQL command used to add a new record into a table.
Primary key: A field that uniquely identifies each record in a table.
Relational database: A database that organises data into multiple related tables, connected through shared fields.
SELECT: The SQL command specifying which columns of data should be retrieved.

What 3.7: Relational Databases and Structured Query Language (SQL) covers

In RADevo this topic has a full topic test and a focused quiz for each part:

3.7.1 Relational Databases
3.7.2 Structured Query Language (SQL)

Teaching AQA GCSE Computer Science (8525)?

Set this topic as homework in two clicks, see who has done it and which questions your class got wrong, and start every lesson with a Do Now built from their mistakes.

Start a free 2-week trial

Revising for this?

If your school uses RADevo, sign in to do the full quizzes and keep your progress. If it doesn't, show this page to your Computing teacher.