Materials – N4/5 DB TRACS Query Task Sheet

Activity Summary

A TRACS exercise for database queries. A set of queries suitable for national 4 and national 5.

Number of Lessons

An introductory lesson with pupils attempting simple examples.

A second lesson to present complex sort / search and calculated / derived data.

PLAN C technique

DB TRACS technique guide can be found here.


Follow Up

  • SQA exam style questions where national 5 pupils have to describe a query.
  • Multi-table database examples can be examined using DB TRACS simply by including columns from the relevant tables. The actual JOIN operation is not addressed here.

You may also like...

Leave a Reply

Your email address will not be published. Required fields are marked *