IGCSE Computer Science Paper 2 Crossword: 8.3 File Handling and 9 Databases (Modules 500–522)
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. The plan for one table: list each field the scenario needs, give it a data type and any validation, and choose a primary key so the table can hold every record. Word 2 of: _____ _________ (9)
- 3. Writes the line held in LineOfText (read earlier from FileA.______) into ______.______, copying it between files. Both files must be opened first and each one closed after. Word 3 of: _________ _____.___, LineOfText (3)
- 6. Word 1 of the term in 3 Across: _________ _____.___, LineOfText (9)
- 9. A ______ holds exactly one ______, like a grade A-E or an M/F code. A text field holds a string of any length, like a name or a postcode. Word 1 of: _________ field (9)
Down
- 1. Open a file for ______, store data with WRITEFILE, then CLOSEFILE. Reopen the same file name for ______ and READFILE gets the data back to use again. Word 1 of: _____, CLOSEFILE, ____ (5)
- 3. A ______ that follows a program step by step, recording the file contents and each variable's value after every file command, until you find the final OUTPUT. Word 2 of: _____ _____ (5)
- 4. Word 2 of the term in 3 Across: _________ _____.___, LineOfText (5)
- 5. The field chosen to identify each record. Its values must be unique and never blank, like an ID number. Names and dates of birth can repeat, so they are unsuitable. Word 2 of: PRIMARY ___ (3)
- 7. Word 3 of the term in 1 Down: _____, CLOSEFILE, ____ (4)
- 8. Word 1 of the term in 3 Down: _____ _____ (5)
Answer Key
IGCSE Computer Science Paper 2 · Modules 500–522
1W
2S
T
R
U
C
T
U
R
E
I
3T
X
T
A
E
B
L
4F
5K
6W
7R
I
8T
E
F
I
L
E
E
R
L
Y
9C
H
A
R
A
C
T
E
R
D
C
B
E
Across
2STRUCTURE — The plan for one table: list each field the scenario needs, give it a data type and any validation, and choose a primary key so the table can hold every record. Word 2 of: _____ _________
3TXT — Writes the line held in LineOfText (read earlier from FileA.______) into ______.______, copying it between files. Both files must be opened first and each one closed after. Word 3 of: _________ _____.___, LineOfText
6WRITEFILE — Word 1 of the term in 3 Across: _________ _____.___, LineOfText
9CHARACTER — A ______ holds exactly one ______, like a grade A-E or an M/F code. A text field holds a string of any length, like a name or a postcode. Word 1 of: _________ field
Down
1WRITE — Open a file for ______, store data with WRITEFILE, then CLOSEFILE. Reopen the same file name for ______ and READFILE gets the data back to use again. Word 1 of: _____, CLOSEFILE, ____
3TABLE — A ______ that follows a program step by step, recording the file contents and each variable's value after every file command, until you find the final OUTPUT. Word 2 of: _____ _____
4FILEB — Word 2 of the term in 3 Across: _________ _____.___, LineOfText
5KEY — The field chosen to identify each record. Its values must be unique and never blank, like an ID number. Names and dates of birth can repeat, so they are unsuitable. Word 2 of: PRIMARY ___
7READ — Word 3 of the term in 1 Down: _____, CLOSEFILE, ____
8TRACE — Word 1 of the term in 3 Down: _____ _____