teach-ict.com logo

THE education site for computer science and ICT

Databases and SQL: Lesson Tasks (Teacher downloads only)

21 Practice Questions

We have written 21 original practice questions for students to work through - you won't find these anywhere else. Answers and explanations are provided for all tasks

(subscription only)

Click Here

 

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