VCE Spreadsheets, SQL & Visualisation Crossword: Relational database structure and Querying data with SQL (Modules 45–54)
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
Across
- 1. An aggregate function works out one value from many rows. COUNT, SUM, AVG, MIN and MAX give the count, total, mean, lowest and highest. This query returns the mean ______. Word 3 of: ______ AVG(_____) FROM _______; (5)
- 2. Fills a new database table from a ______ file. The first row becomes the field names, and you choose a data type for each field, such as text or number, and check them after the ______. Word 2 of: ______ ___ (3)
- 5. Word 2 of the term in 1 Down: ______ ____, age FROM ________; (4)
- 6. Word 5 of the term in 1 Across: ______ AVG(_____) FROM _______; (7)
- 8. An SQL clause that keeps only the rows meeting a condition, such as ______ age >= 15 or ______ town = 'Perth'. Text goes in quotes, and AND or OR can combine conditions. (5)
Down
- 1. ______ lists the fields to show and FROM names the table. This returns the ______ and age columns for every record in ______. ______ * shows all columns. End with a semicolon. Word 5 of: ______ ____, age FROM ________; (8)
- 3. Word 1 of the term in 1 Down: ______ ____, age FROM ________; (6)
- 4. Word 1 of the term in 2 Across: ______ ___ (6)
- 7. A query criterion where the * wildcard stands for any characters, so it finds text that starts with S. ______ "*s" ends with s and ______ "*at*" contains at. Word 1 of: ____ "S*" (4)
- 9. A ______ set on a database field that checks each entry, such as a number range, a maximum text length or a drop-down list, and rejects any record that breaks the ______. Word 2 of: validation ____ (4)
Answer Key
VCE Spreadsheets, SQL & Visualisation · Modules 45–54
1S
C
O
R
E
T
U
2C
3S
V
4I
D
E
M
E
L
P
5N
A
M
E
O
T
C
6R
E
S
U
7L
T
S
T
I
K
8W
H
E
9R
E
U
L
E
Across
1SCORE — An aggregate function works out one value from many rows. COUNT, SUM, AVG, MIN and MAX give the count, total, mean, lowest and highest. This query returns the mean ______. Word 3 of: ______ AVG(_____) FROM _______;
2CSV — Fills a new database table from a ______ file. The first row becomes the field names, and you choose a data type for each field, such as text or number, and check them after the ______. Word 2 of: ______ ___
5NAME — Word 2 of the term in 1 Down: ______ ____, age FROM ________;
6RESULTS — Word 5 of the term in 1 Across: ______ AVG(_____) FROM _______;
8WHERE — An SQL clause that keeps only the rows meeting a condition, such as ______ age >= 15 or ______ town = 'Perth'. Text goes in quotes, and AND or OR can combine conditions.
Down
1STUDENTS — ______ lists the fields to show and FROM names the table. This returns the ______ and age columns for every record in ______. ______ * shows all columns. End with a semicolon. Word 5 of: ______ ____, age FROM ________;
3SELECT — Word 1 of the term in 1 Down: ______ ____, age FROM ________;
4IMPORT — Word 1 of the term in 2 Across: ______ ___
7LIKE — A query criterion where the * wildcard stands for any characters, so it finds text that starts with S. ______ "*s" ends with s and ______ "*at*" contains at. Word 1 of: ____ "S*"
9RULE — A ______ set on a database field that checks each entry, such as a number range, a maximum text length or a drop-down list, and rejects any record that breaks the ______. Word 2 of: validation ____