top of page
Unit 2 Part A Teaching Resource 1 - Normalisation & Validation

TheComputingTutor, is proud to present the first part of a complete Teaching Scheme of Work for IT Unit 2 - Creating Systems to Manage Information.


The resource has been developed with a focus on using Microsoft Access 2019 with over 70 exercises, class tasks, discussion and research activities with suggested answers covering the first part of the Exam Part A - Normalisation and validation.


The resource includes:

  • lessons covering all content required for the exam including lessons on:
  • Database basics including tables, fields and records.
  • Design and Datasheet view.
  • Identifying and creating tables and relationships from supplied data.
  • Creating mapping tables using compound keys.
  • Data validation theory.
  • All types of validation requirements needed for the exam.
  • Nearly 100 differentiated practice database questions with answers.


The Scheme of Work includes two brand-new exam style scenarios that students can use to practice building and normalising a database, all included with worked examples and sample databses.


In addition, sample question and answer databases are provided for each activity right the way through each resource, so if any students miss a lesson, they can use these ready made databases to revise and catch up on any missed progress.


The two practice scenarios will be used consistently through each of the other learning resources.


  • Each lesson includes:

    • A teacher presentation with learning objectives, lesson content and end of lesson review

    • A range of class tasks, from worked examples to discussion activities

    • Student Worksheets for all class tasks

    • Suggested answers for the class tasks to encourage and promote discussion and further learning

    • Resource links to relevant websites and videos that can be used in lesson


Unit 2 Part A Teaching Resource 1 - Normalisation & Validation

  • "The Unit 2 Creating Systems to Manage Information has helped me a lot to teach RDBMS to the BTEC Level 3 students. The resources clearly explain each of the Learning Aims giving clear examples and instructions.

    I would highly recommend this resource for teaching Databases."

    Mr Damian Glyn, Lecturer in IT, North Shropshire College, Shropshire

  • This teaching resource has been designed specifically for the 5 hour exam format that was introduced in 2019. Some of the required content in the original specification has not been included. The exam board requires that this non-examined content still be delivered.

bottom of page