eBook
A 3.3.3 Updating Data in Databases with SQL
SQL can modify databases via INSERT, UPDATE, and DELETE. Indexing impacts update speed and large changes may require index rebuilds. In this section we will explore how Structured Query Language (SQL)...
eBook
A 3.3.2 Constructing Queries in SQL
Querying across two SQL tables involves using JOIN to combine data. Essential elements include relational and logical operators for filtering, LIKE for pattern matching, and ORDER BY for sorting. Key...
eBook
A 3.2.6 Database Scenarios
Learn to construct 3NF databases for real-world scenarios (e.g., library, hospital, e-commerce, school, employee, inventory, crime reporting). Design efficient, normalized databases for practical applications....
Teacher Resources (new)
B 4.1.4 Binary Search Trees - Python (HL Only)
These materials provide three detailed, one-hour lessons for Python. Students will explore BST properties, their use in data organisation, and the core algorithms for insertion, deletion, traversal, and...
Teacher Resources (new)
B 4.1.4 Binary Search Trees - Java (HL Only)
These materials provide three detailed, one-hour lessons for both Java. Students will explore BST properties, their use in data organisation, and the core algorithms for insertion, deletion, traversal,...
/bst.png)
eBook
B 4.1.4 Binary Search Trees (HL Only)
This section explains the structure and properties of BSTs, how they organise data for O(log n) efficiency, and how to perform key operations. Learn to sketch, search, traverse, insert, and delete nodes...
Activities
B 3.2.5 Coding worksheet - Java
Use the following code and copy and paste it into various files in your IDE in a project called DesignPatterns. Instructions: Open your project in your IDE. Complete the coding tasks in order. After each...
Teacher Resources (new)
B 3.2.5 Design Patterns in OOP (HL Only)
This section explains common OOP design patterns, including singleton, factory, and observer. It explores how these patterns are applied to solve recurring programming problems. Relevant ATL Skills: Link...
Activities
B 3.2.5 Coding Worksheet - Python
Students should copy this code from their slides into a single file to begin the worksheet. Task: Modify the Singleton class to track an "access count." Reflection: Task: Add a new animal type to the...
Activities
B 3.2.5 Worksheet Answers
Scenario 1: Game Settings Scenario 2: Shape Creation Scenario 3: Stock Market Updates...