Materials – N4/5 DB TRACS Query Task Sheet
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
- 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.