Teacher Resources (new)
A 3.3.1 Data Language Types
Data Definition Language (DDL) and Data Manipulation Language (DML) are two distinct but equally important categories of SQL commands. DDL is concerned with defining and managing the structure of the...
Teacher Resources (new)
A 3.2.7 Denormalizing databases
Evaluate denormalizing databases. Normalization reduces redundancy, but denormalization speeds up read-heavy apps by reducing joins. This trade-off balances simpler queries with data redundancy risks....
Teacher Resources (new)
A 3.2.4 Constructing Tables
Construct tables for relational databases.Explain the relationship between tables using primary keys, foreign keys, composite keys, and concatenated keys.Discuss the importance of well-defined tables...
Teacher Resources (new)
A 3.2.2 Entity relationship diagrams
ERDs are crucial for creating well-structured databases designed for specific applications. They illustrate relationships between data entities and use cardinality/modality to define these relationships....
eBook
A3.4 Alternative databases and data warehouses (HL only)
HL Subtopic A3.4 explores alternative databases (NoSQL, cloud, spatial, in-memory) and data warehouses. It covers their applications (e-commerce, GIS, analytics, etc.) and data warehouse characteristics...
eBook
A3.3 Database programming
Subtopic A3.3 covers database interaction via SQL, building on fundamentals and design. It focuses on DDL (structure) and DML (data manipulation: insert, update, delete). Students learn to query tables...
eBook
A3.2 Database design
Subtopic A3.2 covers database design: schemas (conceptual, logical, physical), ERDs, data types, table creation (keys), normalisation (1NF-3NF with related concepts), and denormalisation. A3.2.1 Describe...
Teacher Resources (new)
A3 Databases Linking Questions
Linking questions in the 'A3 Databases' topic promote deeper understanding and connect concepts within computer science, fostering a holistic view of the field. They encourage students to see interconnectedness....
Activities
A 3.4.3 Worksheet Answers
Part 1: OLAP in Action Part 2: Identifying Data Mining Techniques Part 3: Discussion...
Activities
A 3.4.3 Worksheet
Part 1: OLAP in Action Imagine a supermarket chain with sales data recorded daily for different products in various stores. For each scenario below, identify which OLAP operation (Roll-up, Drill-down,...