QCE Digital Solutions Unit 2 Crossword: Prototype Data Solutions (Modules 337–409)
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. Adds a new record using ? placeholders filled safely from a tuple of ______. The new row is only saved to the database file once conn.commit() is called. Word 8 of: cursor._______("INSERT INTO products (name, price) ______ (?, ?)", (n, p)) (6)
- 7. Tests whether a field has no value. Use WHERE field ______, often with COUNT(*), to find and count incomplete records when checking data quality. Word 2 of: IS ____ (4)
- 8. Word 2 of the term in 1 Down: _____ ______ != "q": (6)
- 9. Word 3 of the term in 3 Down: DELETE FROM ________ WHERE _________ = ? (8)
Down
- 1. A menu loop repeats: show the menu, read a ______, call that option's function, and stop only when the user picks quit. Other input gets an invalid ______ message. Word 1 of: _____ ______ != "q": (5)
- 2. Loops over each fetched row and prints its fields with an f-string, padded into columns so results are readable. Check for an empty list to show a no records message. Word 5 of: for row in rows: _____(f"{row[0]:<10}{row[1]}") (5)
- 3. A parameterised DELETE or UPDATE run from code: the ? in WHERE is filled by a value so only that record changes. cursor.rowcount of 0 means record not found. Word 5 of: DELETE FROM ________ WHERE _________ = ? (9)
- 4. Run the validation function first and only execute the INSERT or UPDATE when it returns True, so bad data is rejected before SQL runs and never reaches the database. Word 3 of: if is______(points): (5)
- 5. Runs a JOIN query stored in one string. Each row fetched back is a tuple holding fields from both tables, which you can unpack into variables. Word 2 of: cur._______(join_sql) (7)
- 6. Opens a SQLite database file from Python and returns a connection. Call conn.cursor() on it to get a cursor for running SQL, and conn.close() when finished. Word 1 of: _______.connect() (7)
Answer Key
QCE Digital Solutions Unit 2 · Modules 337–409
1W
H
2P
I
3S
R
4V
A
L
U
5E
S
6S
T
I
A
E
X
Q
U
7N
U
L
L
E
L
D
T
I
8C
H
O
I
C
E
D
U
T
N
9S
T
U
D
E
N
T
S
E
3
I
D
Across
4VALUES — Adds a new record using ? placeholders filled safely from a tuple of ______. The new row is only saved to the database file once conn.commit() is called. Word 8 of: cursor._______("INSERT INTO products (name, price) ______ (?, ?)", (n, p))
7NULL — Tests whether a field has no value. Use WHERE field ______, often with COUNT(*), to find and count incomplete records when checking data quality. Word 2 of: IS ____
8CHOICE — Word 2 of the term in 1 Down: _____ ______ != "q":
9STUDENTS — Word 3 of the term in 3 Down: DELETE FROM ________ WHERE _________ = ?
Down
1WHILE — A menu loop repeats: show the menu, read a ______, call that option's function, and stop only when the user picks quit. Other input gets an invalid ______ message. Word 1 of: _____ ______ != "q":
2PRINT — Loops over each fetched row and prints its fields with an f-string, padded into columns so results are readable. Check for an empty list to show a no records message. Word 5 of: for row in rows: _____(f"{row[0]:<10}{row[1]}")
3STUDENTID — A parameterised DELETE or UPDATE run from code: the ? in WHERE is filled by a value so only that record changes. cursor.rowcount of 0 means record not found. Word 5 of: DELETE FROM ________ WHERE _________ = ?
4VALID — Run the validation function first and only execute the INSERT or UPDATE when it returns True, so bad data is rejected before SQL runs and never reaches the database. Word 3 of: if is______(points):
5EXECUTE — Runs a JOIN query stored in one string. Each row fetched back is a tuple holding fields from both tables, which you can unpack into variables. Word 2 of: cur._______(join_sql)
6SQLITE3 — Opens a SQLite database file from Python and returns a connection. Call conn.cursor() on it to get a cursor for running SQL, and conn.close() when finished. Word 1 of: _______.connect()