ACARA Digital Technologies Years 9–10 Crossword: Entities, Relationships and Queries (Modules 459–475)
Name:
Date:
Class:
✎
Crossword
Read each clue and write the matching term in the grid. Numbers in brackets show the letters in each word.
1
2
3
4
5
6
7
8
9
10
Across
- 2. A ______ 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. Word 3 of: multi-table _____ (5)
- 5. ______ matches text by pattern in a ______ 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. Word 1 of: _____ lastName ____ 'S%' (5)
- 6. The join condition: it matches the foreign key in one table to the primary key in the other. The = sign compares the two values to find matching rows. It does not assign a value. Word 3 of: ON orders._________id = _________._________id (8)
- 8. Names the table a ______ comes from, like students.name. Needed in a join when both tables share a ______ name, or SQL gives an ambiguous column error. Word 2 of: table._____ (5)
- 10. Word 5 of the term in 6 Across: ON orders._________id = _________._________id (9)
Down
- 1. A second JOIN line chained after the first to reach a third table. It follows a foreign key in the junction table to the primary key of the next table. Word 2 of: JOIN ________ ON _______.subjectId = ________.subjectId (8)
- 3. Word 4 of the term in 1 Down: JOIN ________ ON _______.subjectId = ________.subjectId (7)
- 4. 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. Word 2 of: Cartesian _______ (7)
- 7. Word 3 of the term in 5 Across: _____ lastName ____ 'S%' (4)
- 9. 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. Word 2 of: BETWEEN ___ AND high (3)
Answer Key
ACARA Digital Technologies Years 9–10 · Modules 459–475
1S
2Q
U
E
R
Y
3R
4P
B
5W
H
E
R
E
R
J
S
6C
U
S
T
O
M
E
R
7L
U
D
C
8F
I
E
L
D
U
T
9L
K
T
10C
U
S
T
O
M
E
R
S
T
W
Across
2QUERY — A ______ 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. Word 3 of: multi-table _____
5WHERE — ______ matches text by pattern in a ______ 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. Word 1 of: _____ lastName ____ 'S%'
6CUSTOMER — The join condition: it matches the foreign key in one table to the primary key in the other. The = sign compares the two values to find matching rows. It does not assign a value. Word 3 of: ON orders._________id = _________._________id
8FIELD — Names the table a ______ comes from, like students.name. Needed in a join when both tables share a ______ name, or SQL gives an ambiguous column error. Word 2 of: table._____
10CUSTOMERS — Word 5 of the term in 6 Across: ON orders._________id = _________._________id
Down
1SUBJECTS — A second JOIN line chained after the first to reach a third table. It follows a foreign key in the junction table to the primary key of the next table. Word 2 of: JOIN ________ ON _______.subjectId = ________.subjectId
3RESULTS — Word 4 of the term in 1 Down: JOIN ________ ON _______.subjectId = ________.subjectId
4PRODUCT — 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. Word 2 of: Cartesian _______
7LIKE — Word 3 of the term in 5 Across: _____ lastName ____ 'S%'
9LOW — 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. Word 2 of: BETWEEN ___ AND high