VCE Spreadsheets, SQL & Visualisation Crossword: Manipulating, validating and testing spreadsheet data and Relational database structure (Modules 35–44)
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
- 4. SQL command that builds a new table by naming its fields and their data types, such as a PRIMARY KEY. INSERT INTO ... VALUES then adds one record to that table. Word 1 of: ______ _____ (6)
- 5. The kind of value a database field accepts, such as text, number, date or yes/no. It stops the wrong kind of ______ being entered, like words in a number field. Word 1 of: ____ ____ (4)
- 6. A tool that summarises a big ______ by grouping rows under row and column fields, then working out a sum, count or average for each group. Refresh it when the data changes. Word 2 of: pivot _____ (5)
- 7. Word 2 of the term in 3 Down: _______ ___ (3)
- 8. Word 2 of the term in 5 Across: ____ ____ (4)
- 9. Word 1 of the term in 4 Down: ______ __________ (6)
Down
- 1. A ______ that stores data in separate tables of fields (columns) and records (rows), with tables linked by shared values such as keys. Word 2 of: __________ ________ (8)
- 2. Word 1 of the term in 1 Down: __________ ________ (10)
- 3. A field whose value is unique for every record in a table, such as a student ID number, so each record can be identified exactly. Names make poor keys because they can repeat. Word 1 of: _______ ___ (7)
- 4. A consistent rule for ______ a database and its tables, such as a singular noun in lower_case with no spaces or special characters, e.g. student, applied in the same style for every table. Word 2 of: ______ __________ (10)
Answer Key
VCE Spreadsheets, SQL & Visualisation · Modules 35–44
1D
2R
3P
4C
R
E
A
T
E
R
O
T
L
I
N
5D
A
T
A
M
V
B
T
6T
A
B
L
E
A
I
R
N
S
O
7K
E
Y
8T
Y
P
E
N
I
A
O
L
9N
A
M
I
N
G
Across
4CREATE — SQL command that builds a new table by naming its fields and their data types, such as a PRIMARY KEY. INSERT INTO ... VALUES then adds one record to that table. Word 1 of: ______ _____
5DATA — The kind of value a database field accepts, such as text, number, date or yes/no. It stops the wrong kind of ______ being entered, like words in a number field. Word 1 of: ____ ____
6TABLE — A tool that summarises a big ______ by grouping rows under row and column fields, then working out a sum, count or average for each group. Refresh it when the data changes. Word 2 of: pivot _____
7KEY — Word 2 of the term in 3 Down: _______ ___
8TYPE — Word 2 of the term in 5 Across: ____ ____
9NAMING — Word 1 of the term in 4 Down: ______ __________
Down
1DATABASE — A ______ that stores data in separate tables of fields (columns) and records (rows), with tables linked by shared values such as keys. Word 2 of: __________ ________
2RELATIONAL — Word 1 of the term in 1 Down: __________ ________
3PRIMARY — A field whose value is unique for every record in a table, such as a student ID number, so each record can be identified exactly. Names make poor keys because they can repeat. Word 1 of: _______ ___
4CONVENTION — A consistent rule for ______ a database and its tables, such as a singular noun in lower_case with no spaces or special characters, e.g. student, applied in the same style for every table. Word 2 of: ______ __________