Year 11 - Key Piece of Work (KPOW)

Year 11 Key Piece of Work: Due 16/3/06

Think of at least six questions to ‘ask’ this database – these will be answered by creating queries which will search the database. Your questions must be realistic, the typical kinds of questions that the Arena staff would want answer to. You should also state a reason for needing to do this search. E.g.

* Search for a person’s contact telephone by surname or membership number
* Search for all the classes taken by a particular instructor
* Search for all the members of a particular class
* Search for all the classes on a particular day
* etc, etc

To be able to search and find the answers in the database, the relevant data must be stored there in the first place. Your KPOW should be written in Word and will consist of text for the questions and reasons, and tables for the query designs (as shown in class).