Databases+Extension+Task

Introduction
You should carry this task out with 3 or more pupils.

Step 1
Each pupil should decide on:

1. A database subject

2. 5 questions they would like that database to be able to answer. 3 questions should be answered by a simple query, 1 question by a complex query (i.e. using 2 fields) and 1 question by a sort

Pupils should write their database subject and 5 questions on a piece of paper

Step 2
Put all of the pieces of paper into a hat, and pupils should take it in turns to draw one out. The pupil must then go off, research and design that database with data to answer that question. The database should have 6 fields and 15 records.

Example
Subject: Music Q1: Which band/artist had a hit single called "By the Way" Q2: Which band/artist had a hit single with "Going Underground" etc.