teach-ict.com logo

THE education site for computer science and ICT

Databases and SQL: Lesson Tasks

Living database

Students are asked to act as records and respond to SQL queries about benign pieces of personal data. A good test of whether they understand the structure of a standard SQL search query.

(subscription only)

download file

task

Workbook and Answers

Students read the theory notes on the mini website and then answer the questions on the task sheet.

(subscription only)

download file

task

download file

answers

Construct an answer

Students are given an exam style question to answer. They are also given a set of key words to incorporate into their answer.

(subscription only)

download file

task

Key terms

Students are asked to provide a definition and example for key terms related to this topic

(subscription only)

download file

task

Matching statements

On the left-hand side is a set of terms. On the right-hand side is a set of statements or definitions. Students are asked to draw a line to matchup the correct term and statement.

(subscription only)

download file

task

download file

answers

Tick the answers

Students are given a number of different statements relating to this topic. They have to decide whether the statement is true or false and place a tick in the correct box.

(subscription only)

download file

task

download file

answers

100 words

Students have exactly 100 words to summarise the key points about this topic

(subscription only)

download file

task

You are the teacher

Students work in small groups to prepare a lesson on this topic. They are provided with information and tips about the tasks they need to prepare.

(subscription only)

download file

task