IB Computer Science 2027 – A3.2.5 Normal Forms – Lesson & Worksheet
IB DP Computer Science 2027 A3.2.5 Normal Forms lesson and worksheet for the new 2027 syllabus.
A classroom-ready resource designed to help students understand database normalisation and explain the differences between the first, second and third normal forms.
What’s Included- Lesson presentation
- Student worksheet
- Classroom activities
- Student tasks
- Normalisation exercises
- Questions to check understanding
- Mark scheme / answers
A3.2.5 – Explain the difference between normal forms
Students explore:
- First Normal Form (1NF)
- Second Normal Form (2NF)
- Third Normal Form (3NF)
- Atomicity
- Unique identification
- Functional dependencies
- Partial-key dependencies
- Non-key and transitive dependencies
- Data duplication and missing data
- The importance of normalisation in relational database design
These areas align with the IB Computer Science 2027 A3.2.5 syllabus requirements. :contentReference[oaicite:0]{index=0}
Suitable For- IB Diploma Programme Computer Science
- Standard Level (SL) and Higher Level (HL)
- New 2027 Computer Science syllabus
- First assessment: May 2027
- Secondary students aged 16–18
Lesson (complete)
A ready-to-use lesson resource including presentation, student worksheet and mark scheme.
This is an original teaching resource and is not affiliated with, endorsed by, or produced by the International Baccalaureate Organization (IBO).
Something went wrong, please try again later.
This resource hasn't been reviewed yet
To ensure quality for our reviews, only customers who have purchased this resource can review it
Report this resourceto let us know if it violates our terms and conditions.
Our customer service team will review your report and will be in touch.
£4.99