QCE Digital Solutions Unit 2 Crossword: Data and Programming Techniques (Modules 234–285)
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
- 2. A menu loop: ______ shows the menu, reads the ______, picks an action with if or else if, and stops on the exit ______. Any other value gets an invalid ______ message. Word 3 of: ______ ... until ______ = 4 (6)
- 3. Loops through the returned records, printing each as a formatted line under a heading, then prints a summary such as a count or total. If there are none, print a no ______ message. Word 3 of: for ____ ______ in _______ (6)
- 6. A relational schema lists each ______ and its fields, marks the primary key (underlined) and foreign keys (FK), and shows how tables link. Word 1 of: _____(PK, field, FK) (5)
- 8. Only insert the record if every validation check left the valid flag ______. If any check set valid to false, skip the bad record or report it instead of inserting it. Word 4 of: if valid = ____ ____ (4)
- 9. Word 5 of the term in 3 Across: for ____ ______ in _______ (7)
Down
- 1. A loop that reads ______ ______, splits it into fields, trims and validates them, then builds an INSERT statement for ______ good row and counts accepted and rejected rows. Word 5 of: for ____ ____ in ____ (4)
- 4. Word 1 of the term in 2 Across: ______ ... until ______ = 4 (6)
- 5. Word 2 of the term in 1 Down: for ____ ____ in ____ (4)
- 7. Word 3 of the term in 1 Down: for ____ ____ in ____ (4)
- 8. Word 3 of the term in 8 Across: if valid = ____ ____ (4)
Answer Key
QCE Digital Solutions Unit 2 · Modules 234–285
1F
2C
H
O
I
C
E
L
3R
E
C
O
4R
D
5E
E
6T
A
B
7L
E
P
C
I
8T
H
E
N
H
N
R
A
9R
E
S
U
L
T
S
E
Across
2CHOICE — A menu loop: ______ shows the menu, reads the ______, picks an action with if or else if, and stops on the exit ______. Any other value gets an invalid ______ message. Word 3 of: ______ ... until ______ = 4
3RECORD — Loops through the returned records, printing each as a formatted line under a heading, then prints a summary such as a count or total. If there are none, print a no ______ message. Word 3 of: for ____ ______ in _______
6TABLE — A relational schema lists each ______ and its fields, marks the primary key (underlined) and foreign keys (FK), and shows how tables link. Word 1 of: _____(PK, field, FK)
8THEN — Only insert the record if every validation check left the valid flag ______. If any check set valid to false, skip the bad record or report it instead of inserting it. Word 4 of: if valid = ____ ____
9RESULTS — Word 5 of the term in 3 Across: for ____ ______ in _______
Down
1FILE — A loop that reads ______ ______, splits it into fields, trims and validates them, then builds an INSERT statement for ______ good row and counts accepted and rejected rows. Word 5 of: for ____ ____ in ____
4REPEAT — Word 1 of the term in 2 Across: ______ ... until ______ = 4
5EACH — Word 2 of the term in 1 Down: for ____ ____ in ____
7LINE — Word 3 of the term in 1 Down: for ____ ____ in ____
8TRUE — Word 3 of the term in 8 Across: if valid = ____ ____