ACARA Digital Technologies Years 9–10 — Entities, Relationships and Queries
Modelling how data relates, and querying it.
Modules (51)
1
Organising data in a table with headings
2
What a single-table database is
3
Counting fields and records in a table
4
Database field data types
5
The repeated-data problem in one big table
6
What is a relational database?
7
Entity
8
Attributes become fields
9
Primary key
10
Choosing a suitable primary key from a table
11
Foreign key and table relationships
12
One-to-many relationships between tables
13
One-to-one and many-to-many relationships
14
Entity relationship diagram: entities and relationship lines
15
Crow's foot notation for one and many
16
Drawing an ERD from a scenario
17
Referential integrity
18
Designing a table structure
19
Naming columns, primary keys and foreign keys
20
What SQL is
21
CREATE TABLE and INSERT INTO
22
SQL column data types and sizes
23
FOREIGN KEY ... REFERENCES in CREATE TABLE
24
What a database query is
25
SQL SELECT and FROM
26
Field order in the output of a SELECT
27
SQL WHERE conditions
28
WHERE on text, Boolean, character and date fields
29
Boolean operators AND, OR and NOT in a WHERE clause
30
Mixing AND and OR with brackets in a WHERE clause
31
Pattern matching with LIKE, % and _
32
BETWEEN and IN in a WHERE clause
33
SQL ORDER BY
34
Clause order in a full SQL query
35
SQL aggregate functions: COUNT, SUM, AVG, MIN, MAX
36
Working out the output of an SQL statement
37
Why a query over two tables needs a join
38
SQL JOIN across two tables
39
Writing the ON condition: foreign key equals primary key
40
Table-qualified field names in a join
41
Table aliases in a join
42
A join with WHERE and ORDER BY
43
Joining three tables
44
A join that forgets the ON condition
45
Query design
46
Writing an SQL query from a requirement
47
Answering a question with a multi-table query
48
Testing a query against the data
49
Common mistakes in SQL scripts
50
SQL UPDATE and DELETE
51
Exporting query results for use in a spreadsheet
Smaller journeys, one per content description
The same modules, split up so a class can take just the content description it's working on.
13
ACARA 9-10 Digital Technologies: Tables, keys and relationships — AC9TDI10P03
Students learn how data is organised in tables, why one big table causes repeated data, and how entities, primary keys, foreign keys and relationships link tables in a relational database.
6
ACARA 9-10 Digital Technologies: Entity relationship diagrams and table design — AC9TDI10P03
Students draw and read entity relationship diagrams, apply referential integrity, and plan and name table structures from a scenario.
4
ACARA 9-10 Digital Technologies: Building tables with SQL — AC9TDI10P03
Students learn what SQL is and use CREATE TABLE, data types, INSERT INTO and FOREIGN KEY ... REFERENCES to build linked tables.
13
ACARA 9-10 Digital Technologies: Querying a single table with SQL — AC9TDI10P03
Students write and trace SELECT queries that filter with WHERE, LIKE, BETWEEN and IN, sort with ORDER BY, and summarise with aggregate functions.
8
ACARA 9-10 Digital Technologies: Joining tables with SQL — AC9TDI10P03
Students use JOIN with ON conditions, qualified names and aliases to combine related tables, including three-table joins and the pitfalls of a missing ON condition.
7
ACARA 9-10 Digital Technologies: Designing, testing and applying queries — AC9TDI10P03
Students plan queries, answer questions across tables, test and debug SQL, change data with UPDATE and DELETE, and export results to a spreadsheet.
Printables for this journey
Every module above has its own free printable worksheet with an answer key. These crosswords and word searches cover the same terms:
✎
Years 5–6 Data & Information Crossword: Data, information and binary representation and Acquiring and manipulating data (Modules 11–20)
10 clues · Representing images with pixels, Primary and secondary data sources, Collecting data with a survey, Spreadsheet rows, columns and cells and more
🔎
Years 5–6 Data & Information Word Search: Data, information and binary representation and Acquiring and manipulating data (Modules 1–20)
20 words to find · Data and information, Types of data: numbers and text, Types of data: images, sound and video, Same data, different representations and more
✎
VCE Data Analysis Crossword: Requirements, constraints and scope and Design tools for databases, spreadsheets and visualisations (Modules 68–80)
10 clues · Scope of a solution, Listing requirements and constraints for a problem, Interpreting teacher-provided requirements for a data solution, Input-process-output (IPO) chart and more
🔎
VCE Data Analysis Word Search: Ethics and APA referencing to Design tools for databases, spreadsheets and visualisations (Modules 56–80)
22 words to find · Acknowledging sources and copyright, Purpose of APA referencing, APA in-text citations, APA reference list entry structure and more
✎
VCE Spreadsheets, SQL & Visualisation Crossword: Manipulating, validating and testing spreadsheet data and Relational database structure (Modules 35–44)
10 clues · Pivot tables, What is a relational database?, What a single-table database is, Database field data types and more
✎
VCE Spreadsheets, SQL & Visualisation Crossword: Relational database structure and Querying data with SQL (Modules 45–54)
10 clues · Importing a CSV file into a database table, Validation rules on database fields, SQL constraints for validation, What a database query is and more
✎
VCE Spreadsheets, SQL & Visualisation Crossword: Querying data with SQL to Purposes and types of data visualisations (Modules 55–70)
10 clues · SQL GROUP BY, SQL JOIN across two tables, SQL UPDATE and DELETE, Testing a query against the data and more
🔎
VCE Spreadsheets, SQL & Visualisation Word Search: Manipulating, validating and testing spreadsheet data to Querying data with SQL (Modules 35–54)
20 words to find · Pivot tables, What is a relational database?, What a single-table database is, Database field data types and more
🔎
VCE Spreadsheets, SQL & Visualisation Word Search: Querying data with SQL to Visualisation components and design conventions (Modules 55–86)
20 words to find · SQL GROUP BY, SQL JOIN across two tables, SQL UPDATE and DELETE, Testing a query against the data and more
✎
VCE Data Analytics U3O1 Crossword: Data types and relational databases to Sourcing, validating and referencing data (Modules 17–49)
10 clues · Field sizes, SQL column data types and sizes, One-to-many relationships between tables, Boolean operators AND, OR and NOT in a WHERE clause and more
🔎
VCE Data Analytics U3O1 Word Search: Data types and relational databases to Statistical analysis of data (Modules 17–91)
20 words to find · Field sizes, SQL column data types and sizes, One-to-many relationships between tables, Boolean operators AND, OR and NOT in a WHERE clause and more
✎
IGCSE Computer Science Paper 2 Crossword: 8.3 File Handling and 9 Databases (Modules 500–522)
10 clues · Write, close, then read the data back, Copying a line of text from one file to another, Tracing a file handling program, Common mistakes in file handling pseudocode and more
✎
IGCSE Computer Science Paper 2 Crossword: 9 Databases (Modules 525–538)
10 clues · Field order in the output of a SELECT, WHERE on text, Boolean, character and date fields, Mixing AND and OR with brackets in a WHERE clause, Clause order in a full SQL query and more
✎
IGCSE Computer Science Paper 2 Crossword: 9 Databases and 10 Boolean Logic (Modules 539–551)
10 clues · Common mistakes in SQL scripts, What a logic gate is, Labelling inputs and the output: A, B, C and X, Truth table layout for two inputs and more
🔎
IGCSE Computer Science Paper 2 Word Search: 8.3 File Handling and 9 Databases (Modules 500–538)
20 words to find · Write, close, then read the data back, Copying a line of text from one file to another, Tracing a file handling program, Common mistakes in file handling pseudocode and more
🔎
IGCSE Computer Science Paper 2 Word Search: 9 Databases and 10 Boolean Logic (Modules 539–580)
20 words to find · Common mistakes in SQL scripts, What a logic gate is, Labelling inputs and the output: A, B, C and X, Truth table layout for two inputs and more
✎
Crossword: Entities, Relationships and Queries (Modules 433–451)
10 clues · The repeated-data problem in one big table, Entity, Attributes become fields, One-to-one and many-to-many relationships and more
✎
Crossword: Entities, Relationships and Queries (Modules 459–475)
10 clues · Pattern matching with LIKE, % and _, BETWEEN and IN in a WHERE clause, Why a query over two tables needs a join, Writing the ON condition: foreign key equals primary key and more
🔎
Word Search: Analysing and Visualising Data and Entities, Relationships and Queries (Modules 413–451)
21 words to find · Connecting one slicer to several pivot charts, Referencing a cell on another worksheet, Named ranges, A drop-down list as a chart selector and more
🔎
Word Search: Entities, Relationships and Queries and Algorithms with Logical Operators (Modules 459–534)
22 words to find · Pattern matching with LIKE, % and _, BETWEEN and IN in a WHERE clause, Why a query over two tables needs a join, Writing the ON condition: foreign key equals primary key and more
Frequently Asked Questions
Are these worksheets free?
Yes — every worksheet and its answer key is free to view, download, and print, with no account required to access any individual module.
Do I need an account?
No account is needed to view or print a worksheet. A free teacher account adds extras like assigning modules to a class and tracking progress automatically — it takes under three minutes to set up and doesn't need a credit card.
What year level is this for?
This curriculum is aligned to the Australian Curriculum (ACARA) and Victorian Curriculum, spanning roughly Years 3 to 10 — from first sequencing and variables through to object-oriented programming and advanced data structures. Start wherever matches your class's current level; each module builds on the last.
Can I print them?
Yes — every module has a one-click Print Worksheet button that generates a printable page with the practice questions and a full answer key.
Is this aligned to a curriculum?
Yes — the module sequence is mapped to the Australian Curriculum (ACARA) and Victorian Curriculum, and a class's progress is reported back against those curriculum bands (e.g. ACARA Years 5–6 sequencing and iteration, Years 7–8 functions and data structures), not just a generic difficulty scale.
Can students use this without a teacher?
Yes — students can start any module and practice directly, no class or account required. Joining a teacher's class with a class code adds progress tracking, class badges, and live Sprints, but isn't needed to work through the worksheets or modules solo.
Do I need to know ACARA Digital Technologies Years 9–10 myself to teach this?
No — every module comes with a full worked answer key, and Cloodit tracks who's stuck automatically, so you don't need to solve each exercise yourself before assigning it or be able to debug a student's work line by line.
For Teachers
Add this journey to your class and track every student in real time.
Create a free teacher account →No credit card. No setup fee. Make a class and invite students in under three minutes.
For Students
Start this journey on Cloodit — track progress, earn badges, and play live sprints with your class.
Start Learning Free →