ACARA Digital Technologies Years 9–10 Word Scramble: Entities, Relationships and Queries (Modules 459–475)
Name:
Date:
Class:
🔤
Word scramble
Unscramble the letters and write each key term on the line.
1
REEHW MNEALAST IKLE 'S%'
LIKE matches text by pattern in a WHERE clause. % stands for any run of characters and _ for exactly one, so 'S%' finds values starting with S and '%son' finds values ending in son.
2
ETBNEWE WLO DAN IGHH
Tests if a value is inside a range, including both limits. Its partner IN (a, b, c) checks a value against a list, replacing repeated OR. NOT IN excludes the list.
3
NJOI
A ______ matches each foreign key value in one table to the primary key value in another, so rows from both tables show together. Rows with no match are left out.
4
LDEAL.TBIFE
Names the table a field comes from, like students.name. Needed in a join when both tables share a field name, or SQL gives an ambiguous column error.
5
OMFR EUTDNSTS S
Gives the students table the short name s after FROM, so the rest of the query can write s.firstName instead of students.firstName.
6
NIJO ... NO ... REEHW ... DEROR YB
After JOIN ... ON links two tables, WHERE filters the joined rows and ORDER BY sorts them. Clause order: SELECT, FROM, JOIN ON, WHERE, ORDER BY.
7
ICAETNRAS CUTPORD
A join with no ON condition pairs every row of one table with every row of the other, so 3 customers and 4 orders give 12 rows, most of them wrong.
8
ETBLL-IMATU UQREY
A query that gets fields from more than one table: find which tables hold them, JOIN them on matching keys, then add WHERE and ORDER BY to match the question.
Answer Key
ACARA Digital Technologies Years 9–10 · Modules 459–475
1REEHW MNEALAST IKLE 'S%' → WHERE lastName LIKE 'S%' — LIKE matches text by pattern in a WHERE clause. % stands for any run of characters and _ for exactly one, so 'S%' finds values starting with S and '%son' finds values ending in son.
2ETBNEWE WLO DAN IGHH → BETWEEN low AND high — Tests if a value is inside a range, including both limits. Its partner IN (a, b, c) checks a value against a list, replacing repeated OR. NOT IN excludes the list.
3NJOI → JOIN — A join matches each foreign key value in one table to the primary key value in another, so rows from both tables show together. Rows with no match are left out.
4LDEAL.TBIFE → table.field — Names the table a field comes from, like students.name. Needed in a join when both tables share a field name, or SQL gives an ambiguous column error.
5OMFR EUTDNSTS S → FROM students s — Gives the students table the short name s after FROM, so the rest of the query can write s.firstName instead of students.firstName.
6NIJO ... NO ... REEHW ... DEROR YB → JOIN ... ON ... WHERE ... ORDER BY — After JOIN ... ON links two tables, WHERE filters the joined rows and ORDER BY sorts them. Clause order: SELECT, FROM, JOIN ON, WHERE, ORDER BY.
7ICAETNRAS CUTPORD → Cartesian product — A join with no ON condition pairs every row of one table with every row of the other, so 3 customers and 4 orders give 12 rows, most of them wrong.
8ETBLL-IMATU UQREY → multi-table query — A query that gets fields from more than one table: find which tables hold them, JOIN them on matching keys, then add WHERE and ORDER BY to match the question.