Pearson Level 3 AAQ BTEC National in IT · Internal Unit

Unit 4 — Relational Database Development

Learn how relational databases are modelled, normalised and built — then get step-by-step support to score a Distinction in your assignment.

Part 1 Free to revise

Part 1 · Learn the theory

Everything you need for Learning Aims A, B and C — how databases are modelled, normalised and built.

Study guide — every spec topic explained with examples, tables and tips
Revise — knowledge-check MCQs, a quick quiz and flashcards
SQL Lab — write real SQL against a sample database and see the results
Normalisation Lab — practise splitting tables from UNF to 3NF
MS Access tutorials — step-by-step, click-by-click guides to building your database in Access

Part 2 Assignment support

Part 2 · Win your assignment

Three tasks. One goal: Distinction. Work through the walkthroughs, practise on sample briefs, then upload your own work for AI marking.

Task-by-task walkthroughs — exactly what to produce for Pass, Merit and Distinction
Sample briefs — realistic practice scenarios with full design documentation
Upload your assignment — AI Assigner marks it against the real criteria and shows where to improve
Evidence checklists — make sure you submit everything required

How this unit is structured

Learning Aims & assignments

This is an internal unit assessed by a Pearson Set Assignment (3 tasks). The theory in Part 1 feeds directly into the tasks in Part 2.

Revise

Choose a fun way to revise! 💡

🃏

Flashcards

Flip through cards for rapid recall and spaced repetition.

Open flashcards

Key terms and concepts across Aims A, B and C — track your progress!

❓

Quiz

Multiple-choice questions with instant feedback.

Start quiz

Test your knowledge and get explanations for every answer.

📖

Revision Guide

Full topic-by-topic breakdown with worked examples and diagrams.

Open revision guide

Every spec topic explained for Aims A, B and C.

📘

Revision Booklets

Printable booklet + solutions for every aim, with normalisation, ERD and data-dictionary model answers.

Print a revision booklet

Choose any aim, toggle solutions, then print or save as PDF.

Open booklets

📄

Learning Aims Reference

Clean, readable guides for each learning aim.

View Learning Aims

Quick Quiz

12 mixed questions across Aims A, B and C with a score at the end.

Flashcards

Flip through cards for rapid recall.

Unit Specification

The published spec content areas mapped to this app. Click any topic to jump to it in the study guide.

Tools

Practise SQL, normalisation and Microsoft Access — the hands-on skills behind Aim B and Aim C.

💻

SQL Lab

Write real SQL and see the results.

Open the SQL Lab

Run SELECT / INSERT / UPDATE / DELETE against a sample college-enrolment database and watch the result table update live.

🗂️

Normalisation Lab

Practise UNF → 3NF.

Open the Normalisation Lab

Work through interactive examples that split a flat table into 1NF, 2NF and 3NF with instant checking.

📘

Microsoft Access Tutorials

Click-by-click guides.

Master Access step-by-step

Tables, relationships, queries, forms, reports and macros — clear numbered steps for every assignment task.

🖥️

Access Lab

Fake MS Access — build your own database.

Practise with real GUI tools

A simulated Access with tables, Design View, relationships, query design, forms and reports — create your own database from scratch or load a template.

SQL Lab

Write real SQL against a sample college-enrolment database. Type a query, run it, and see the result table update instantly.

Normalisation Lab

Interactive walkthroughs that split a flat table into 1NF, 2NF and 3NF — the exact skill Aim A tests.

Microsoft Access Tutorials

Step-by-step, click-by-click guides to building your assignment database in Microsoft Access.

Access Lab

A simulated Microsoft Access — build your own database with tables, relationships, queries, forms and reports using the real GUI tools. No software install needed.

Assignment

Download a sample assignment to work on, then follow the step-by-step guide to meet exactly what Pearson wants to see for Pass, Merit and Distinction.

AI Assigner

Your personal Unit 4 mentor — chat, get hints on normalisation/SQL/design, or upload your work for marking. It coaches you to do the work yourself.

Your Progress

Track your revision streak, study guide aims, flashcards and quiz scores.