IB Computer Science 2027 – A3.3.2 Constructing Queries in SQL – Lesson & Worksheet

IB Computer Science 2027 – A3 Databases Complete Bundle

# IB Computer Science 2027 – A3 Databases Complete Bundle A complete teaching resource bundle covering Topic A3: Databases for the new IB Computer Science 2027 syllabus. This bundle includes 18 classroom-ready lessons covering database fundamentals, relational database design, SQL programming and alternative database systems. Each lesson includes a presentation, student worksheet and mark scheme. ## What's Included - 18 lesson presentations - 18 student worksheets - 18 mark schemes / answer documents - Classroom activities - Student tasks - Real-world database scenarios - SQL practice and database design exercises - Exam-focused questions - Resources for both SL and HL ## Syllabus Coverage ### A3.1 – Database Fundamentals - A3.1.1 Relational Databases - A3.1.2 Database Schemas - A3.1.3 Entity Relationship Diagrams - A3.1.4 Data Types - A3.1.5 Constructing Tables ### A3.2 – Database Design - A3.2.1 Normal Forms - A3.2.2 Database Scenarios - A3.2.3 Denormalizing Databases ### A3.3 – Database Programming - A3.3.1 Data Language Types - A3.3.2 Constructing Queries in SQL - A3.3.3 Updating Data with SQL - A3.3.4 SQL Aggregate Functions - A3.3.5 Database Views - A3.3.6 Database Transactions ### A3.4 – Alternative Databases - A3.4.1 Different Types of Databases - A3.4.2 Data Warehouses - A3.4.3 OLAP and Data Mining - A3.4.4 Distributed Databases ## 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 ## Resource Type **Complete Bundle** A comprehensive, ready-to-use resource for teaching Topic A3: Databases, with presentations, worksheets and mark schemes for every lesson. The new IB Computer Science course is first assessed in May 2027. :contentReference[oaicite:0]{index=0} *These are original teaching resources and are not affiliated with, endorsed by, or produced by the International Baccalaureate Organization (IBO).*