VCE Spreadsheets, SQL & Visualisation Word Scramble: Manipulating, validating and testing spreadsheet data and Relational database structure (Modules 35–44)
Name:
Date:
Class:
🔤
Word scramble
Unscramble the letters and write each key term on the line.
1
OTVIP AELBT
A tool that summarises a big table 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.
2
TIAELONLAR TEBADASA
A database that stores data in separate tables of fields (columns) and records (rows), with tables linked by shared values such as keys.
3
ATDBSAAE BAETL
A ______ stores data in columns called fields and rows called records. A single-table database keeps all its data in this one table.
4
AADT PETY
The kind of value a database field accepts, such as text, number, date or yes/no. It stops the wrong kind of data being entered, like words in a number field.
5
ARIYMRP YKE
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.
6
GFONRIE YKE
A field in one table that holds the primary key value of a record in another table, linking the two tables together so related data is stored once and not repeated.
7
INMNGA OOCNIVENNT
A consistent rule for naming 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.
8
TITEDND_SU
A key column name in lowercase with an _id suffix. A primary key uses it in its own table, and a foreign key reuses the exact same name in a related table.
9
LEATB NSIDEG
Planning a table by listing a clear field name and data type for each piece of data, with one fact per field, such as FirstName and LastName as two fields.
10
ERTCEA LAEBT
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.
Answer Key
VCE Spreadsheets, SQL & Visualisation · Modules 35–44
1OTVIP AELBT → pivot table — A tool that summarises a big table 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.
2TIAELONLAR TEBADASA → relational database — A database that stores data in separate tables of fields (columns) and records (rows), with tables linked by shared values such as keys.
3ATDBSAAE BAETL → database table — A database table stores data in columns called fields and rows called records. A single-table database keeps all its data in this one table.
4AADT PETY → data type — The kind of value a database field accepts, such as text, number, date or yes/no. It stops the wrong kind of data being entered, like words in a number field.
5ARIYMRP YKE → PRIMARY KEY — 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.
6GFONRIE YKE → FOREIGN KEY — A field in one table that holds the primary key value of a record in another table, linking the two tables together so related data is stored once and not repeated.
7INMNGA OOCNIVENNT → naming convention — A consistent rule for naming 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.
8TITEDND_SU → student_id — A key column name in lowercase with an _id suffix. A primary key uses it in its own table, and a foreign key reuses the exact same name in a related table.
9LEATB NSIDEG → table design — Planning a table by listing a clear field name and data type for each piece of data, with one fact per field, such as FirstName and LastName as two fields.
10ERTCEA LAEBT → CREATE TABLE — 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.