Databases (Organising Information) for KS3 Computing: 3 ready-made live quiz games, 45 questions in all.
The questions cover Sorting and Criteria, Structured Data, Data Types & Primary Key, Entities, keys and one-to-many, Foreign Keys and Database Recap.
There are 2 practice sets and 1 quickfire round. Question types: 36 true or false, 8 fill the gap and 1 multiple choice.
Pick a set, put the join code on the board and pupils play on their phones. Pupils need no account. Free for teachers, up to 40 players.
The gamesEach set is a fixed list of questions. Open a preview to see a few of them.
Quickfire: Databases (Organising Information)
KS315 questions· Warm-up
Plays in 17 of 17 game modes, including Gold Rush, Big Catch and Speed Blitz.
Preview 3 sample questions
- 1
Databases: true or false?
A field is one row of the table.
- 2
True or false?
Ascending order for numbers goes from largest to smallest.
- 3
True or false?
ORDER BY can only sort results in ascending order.
+ 12 more questions in the game.
Practice
Databases (Organising Information): Sorting and Criteria
KS315 questions· Core
Plays in 17 of 17 game modes, including Gold Rush, Big Catch and Speed Blitz.
Preview 3 sample questions
- 1
True or false?
Filtering a table can reduce the number of records shown, based on a condition.
- 2
Linking tables: true or false?
A primary key is allowed to hold the same value in two different records.
- 3
Sorting records into order from largest to smallest is called ____ order.
ascendingdescendingANDfiltering
+ 12 more questions in the game.
Practice
Databases (Organising Information): Quoting and sorting rules
KS315 questions· Core
Plays in 17 of 17 game modes, including Gold Rush, Big Catch and Speed Blitz.
Preview 3 sample questions
- 1
SQL: true or false?
You use WHERE, not ORDER BY, to sort the results into order.
- 2
SQL: true or false?
ORDER BY Price DESC sorts the results from the smallest price to the largest.
- 3
Databases: true or false?
A jumble of holiday photos with no names or tags is an example of structured data.
+ 12 more questions in the game.
How hosting works
- Pick a set and a game mode. The questions stay the same; the game changes.
- Put the join code on the board. Pupils join at subjecthub.co.uk/play on a phone or laptop. They need no account.
- Play for 1 to 7 minutes. You choose the length before you start.
Free for teachers: host these sets with up to 40 players. You sign up once as a teacher.
See how each game mode plays →
← All KS3 Computing games · All live games