eBook
Network Fundamentals
This section of the ebook covers the basic configuration of networks how networks are constructed, the standards they are built on and elements of virtual private networks. Last updated: 19 Feb 2026...
Teacher Resources (new)
A 3.4.2 Data warehouses (HL Only)
Efficient data storage and analysis rely on append-only, subject-oriented, integrated, time-variant, and non-volatile data, optimised for query performance. Updated 18/02/2026 By the end of this lesson,...
Teacher Resources (new)
A 3.2.5 Normal Forms
This section explains normal forms (1NF, 2NF, 3NF) in relational databases. It covers atomicity, unique identification, functional/partial-key/transitive dependencies. Normalization reduces data duplication,...
Activities
A 3.4.2 Activity Worksheet
A Data Warehouse (OLAP) is different from a standard transactional database (OLTP). While operational databases are designed for fast daily transactions (like buying a ticket), data warehouses are designed...
Teacher Resources (new)
A 3.3.6 Database Transactions (HL Only)
Database transactions ensure data integrity via ACID properties (Atomicity, Consistency, Isolation, Durability). TCL commands (BEGIN TRANSACTION, COMMIT, ROLLBACK) manage transaction boundaries. By the...
Activities
A 3.3.6 Worksheet
Instructions: Answer the following questions based on your understanding of database transactions and the ACID properties. Part 1: Identifying ACID Properties Read the following scenarios and identify...
Teacher Resources (new)
A 3.3.5 Database views (HL Only)
Virtualized and materialized database views offer flexible and performant data access. Virtual views provide dynamic, logical perspectives for flexibility and security. Materialized views store pre-computed...
Activities
A 3.3.5 Worksheet
Objective: To understand and use virtual database views in DB Browser for SQLite. Scenario: You have a simple database with two tables: Customers and Orders. Customers Table: Orders Table: Instructions:...
Activities
A 3.3.5 Worksheet Answers
Objective: To understand and use virtual database views in DB Browser for SQLite. Scenario: You have a simple database with two tables: Customers and Orders. Customers Table: Orders Table: Instructions:...
Teacher Resources (new)
A 3.3.4 SQL Aggregate functions (HL Only)
SQL aggregate functions (AVG, COUNT, MAX, MIN, SUM) perform calculations on grouped data for reporting and decision-making within a database. (HL only). Updated 17/02/2026 By the end of this lesson, students...