Professional Learning And Networking for Computing
Information Systems Development material aimed at implementing 2 or 3 table relational databases.
Activity Summary This is a series of practical tasks that focus on the relational database content of the N5 Computing Science course. All of the practical work is completed in MS Access. However, with a updated Help sheet (the current resource is based on VB...
Activity Summary This activity allows students to gain an understanding of how SQL queries are executed. This is an introductory lesson that requires the teacher to demonstrate and explain that underlying all database queries is SQL code. The focus of the lesson is to introduce...
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...
