New to PG?
Start here
BooksBusinessComputingDesign & TechnologyEnglishHumanitiesLanguagesMathsPEScienceClearReviseAI TutorAbout
Back to All Units

BTEC L3 IT

£110.00 + VAT Discounted rate from £88.00

+

AAQ Unit 4 Pack B Part 1

Unit 4 Relational database design and documentation

B

Inside the Unit...

AAQ Unit 4 Pack B Part 1

Download Free Sample 6.0mb

Areas Covered

  • Topic 1 Entities, relationships and relational algebra
  • Download sample lesson above
  • Topic 2 DBMS and database implementation
  • Topic 3 Design specification and client requirements
  • Topic 4 Data structure designs
  • Topic 5 Forms and menus
  • Assessment

There are 5 worksheets, 5 homework tasks, and an assessment test, each with answers included in this unit.

Summary

NEW for the 2025 AAQ specification.

This pack of resources covers the specification points for B1 (relational database design) and the first half of B2 (design documentation). Five topics are included along with an end-of-unit assessment. Example database structures and contexts allow students to clearly understand how the design specification is applied. The first two topics focus on relational database design techniques and processes. Students will have already met many of the concepts, so these lessons give additional opportunity for review. Topic 3 looks at the design specification overall and specifically the requirements of the brief, audience, purpose, client requirements and legal and ethical considerations. Topic 4 shows students how to use data dictionaries and entity relationship diagrams. In the last topic, students will look at how to design forms and menus along with the components that are used within database forms. After the final topic there is an opportunity for students to sit an assessment test which helps to review the material covered before they undertake the project brief.

What's included in the toolkit?

The various elements of the unit

The AAQ BTEC Teaching Series has been written to satisfy the new specification for Unit 4 of the Pearson BTEC Level 3 specification. Each pack contains:

  • PowerPoint slides for each lesson
  • Detailed lesson plans
  • Learning objectives and outcomes
  • Worksheets and homework activities with answers
  • End-of-unit Assessment test with answers
  • Other material and links to online resources

What people say...

“
”

I really like your resources that are engaging and challenging for students at every level. Your lesson plans are in detail, showing very clear differentiation. I will highly recommend you to any teachers who are looking for dynamic and relevant SOW.

Songul Adams. Head of Computing, Everest Community Academy

“
”

The PG Online materials have made a huge impact on me and my students. It’s a well developed set of resources that any computer science teacher can use.

Will Chau. IT and Computer Science Teacher, The ISF Academy, Hong Kong

People also bought...

Relevant Textbooks

Inside the Unit...

AAQ Unit 4 Pack B Part 1

  • Download Free Sample 6.0mb

    Areas Covered

    • Topic 1 Entities, relationships and relational algebra
    • Download sample lesson above
    • Topic 2 DBMS and database implementation
    • Topic 3 Design specification and client requirements
    • Topic 4 Data structure designs
    • Topic 5 Forms and menus
    • Assessment

    There are 5 worksheets, 5 homework tasks, and an assessment test, each with answers included in this unit.

  • How to order

    1. Add individual units to a draft order or download a blank order form below to complete manually

    2. Using a draft order you can either:

    1. Save your order online
      (registration or log in required)
    2. Email us your complete order
      (registration or log in required)
    3. Create a PDF
      (to fax or email at a later date)

    Download blank order form

    PDF

    Word

  • Unit Pricing and Discounts

    Each unit is individually priced for LIFE. Please view each unit for detail. 

    Discounts are cumulative based on the total number of units licenced to your department.

    All prices subject to further discounts and VAT.

    There are no annual renewal fees.

    2-5 units 10% discount
    6-11 units 15% discount
    12+ units 20% discount