VCE Spreadsheets, SQL & Visualisation Word Scramble: Relational database structure and Querying data with SQL (Modules 45–54)
Name:
Date:
Class:
🔤
Word scramble
Unscramble the letters and write each key term on the line.
1
TIORMP SCV
Fills a new database table from a CSV 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 import.
2
AIVALDIOTN ELUR
A rule 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 rule.
3
RYUEQ
A saved question asked of a table. It shows only the fields and records that answer it, as a new view, and leaves the original table unchanged.
4
EWHER
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
DNA / RO
AND needs both conditions to be true, like Year = 7 AND Score > 80. OR needs at least one to be true, like Pet = "Cat" OR Pet = "Dog". They let a query match several conditions at once.
6
ILKE "S*"
A query criterion where the * wildcard stands for any characters, so it finds text that starts with S. Like "*s" ends with s and Like "*at*" contains at.
7
ERRDO YB
Sorts the rows a SELECT query returns by a chosen field. It sorts A to Z or lowest to highest by default (ASC), or the reverse if you add DESC after the field name.
Answer Key
VCE Spreadsheets, SQL & Visualisation · Modules 45–54
1TIORMP SCV → Import CSV — Fills a new database table from a CSV 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 import.
2AIVALDIOTN ELUR → validation rule — A rule 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 rule.
3RYUEQ → query — A saved question asked of a table. It shows only the fields and records that answer it, as a new view, and leaves the original table unchanged.
4EWHER → WHERE — An SQL clause that keeps only the rows meeting a condition, such as WHERE age >= 15 or WHERE town = 'Perth'. Text goes in quotes, and AND or OR can combine conditions.
5DNA / RO → AND / OR — AND needs both conditions to be true, like Year = 7 AND Score > 80. OR needs at least one to be true, like Pet = "Cat" OR Pet = "Dog". They let a query match several conditions at once.
6ILKE "S*" → Like "S*" — A query criterion where the * wildcard stands for any characters, so it finds text that starts with S. Like "*s" ends with s and Like "*at*" contains at.
7ERRDO YB → ORDER BY — Sorts the rows a SELECT query returns by a chosen field. It sorts A to Z or lowest to highest by default (ASC), or the reverse if you add DESC after the field name.