There are 3 worksheets in this unit and 3 pre-populated sample databases.
Summary - New: 3rd Edition
This unit covers essential theory of databases in order to prepare pupils for GCSEs in either Computing or ICT. Supporting the basic theory, this unit has a practical focus, covering the creation and use of a single-table database and/or a simple relational database involving two tables in a one- to-many relationship using MS Access.
The first lesson is designed to engage pupils in the concept of databases using a number of “Unsolved Crimes” and a database of suspects, from which pupils must use queries to find the culprit for each of the cases they have been allocated.
In subsequent lessons pupils will create a flat-file or two-table relational database of their own, using suitable field types and adding in appropriate validations. They will create an input form, queries, a report and a front end menu for their own application. Two populated database have been included for demonstration of these skills by the teacher.
What's included in the toolkit?
The currently available units have been written to satisfy the new National Curriculum for Computing, they are designed for teaching at KS3 but individual lessons in some units may also be appropriate for teaching Key Stages 2 or 4, particularly where Year 10 students may not previously have been exposed to certain topics.
