WA Computer Science ATAR Unit 2 Crossword: Data Management and Cyber Security (Modules 28–122)
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
10
Across
- 6. A field is functionally dependent on another when the other field's value determines it. The determinant fixes the value: studentId determines studentName. Word 1 of: __________ dependency (10)
- 8. Take a table through 1NF, 2NF, then 3NF by removing repeating groups, then partial dependencies, then transitive dependencies, giving each new table its own key. Word 1 of: _________ to ___ (9)
- 9. A composite ______ ______: two or more fields together identify each record uniquely. Each field can repeat alone, but the pair cannot. Used in junction tables. Word 2 of: _______ ___ (studentId, subjectId) (3)
- 10. Word 1 of the term in 9 Across: _______ ___ (studentId, subjectId) (7)
Down
- 1. Authorised users can reach data and systems when they need them. Attacks like DDoS and hardware failure reduce it. (12)
- 2. A table is in ______ when every field holds one atomic value, there are no repeating groups, and each record is identified by a key. (3)
- 3. ______ marks a missing value. Test for it with ______ or IS NOT ______, because = ______ never matches. ______ is not a blank or 0, and aggregates ignore it. Word 2 of: IS ____ (4)
- 4. A problem caused by redundant data in one table: adding, changing or deleting a record leads to missing data, inconsistent copies or accidental loss of other facts. Word 2 of: data _______ (7)
- 5. Data stays accurate, complete and unaltered unless an authorised person changes it. Tampering breaks ______ by altering data without permission. (9)
- 7. A table in 2NF where no non-key field depends on another non-key field. Every field depends on the key, the whole key and nothing but the key. (3)
Answer Key
WA Computer Science ATAR Unit 2 · Modules 28–122
1A
V
A
I
L
21
A
3N
N
4A
B
5I
U
6F
U
N
C
T
I
O
N
A
L
73
O
L
T
L
8N
O
R
M
A
L
I
S
E
F
A
T
G
L
Y
R
9K
E
Y
I
T
10P
R
I
M
A
R
Y
Across
6FUNCTIONAL — A field is functionally dependent on another when the other field's value determines it. The determinant fixes the value: studentId determines studentName. Word 1 of: __________ dependency
8NORMALISE — Take a table through 1NF, 2NF, then 3NF by removing repeating groups, then partial dependencies, then transitive dependencies, giving each new table its own key. Word 1 of: _________ to ___
9KEY — A composite ______ ______: two or more fields together identify each record uniquely. Each field can repeat alone, but the pair cannot. Used in junction tables. Word 2 of: _______ ___ (studentId, subjectId)
10PRIMARY — Word 1 of the term in 9 Across: _______ ___ (studentId, subjectId)
Down
1AVAILABILITY — Authorised users can reach data and systems when they need them. Attacks like DDoS and hardware failure reduce it.
21NF — A table is in ______ when every field holds one atomic value, there are no repeating groups, and each record is identified by a key.
3NULL — ______ marks a missing value. Test for it with ______ or IS NOT ______, because = ______ never matches. ______ is not a blank or 0, and aggregates ignore it. Word 2 of: IS ____
4ANOMALY — A problem caused by redundant data in one table: adding, changing or deleting a record leads to missing data, inconsistent copies or accidental loss of other facts. Word 2 of: data _______
5INTEGRITY — Data stays accurate, complete and unaltered unless an authorised person changes it. Tampering breaks ______ by altering data without permission.
73NF — A table in 2NF where no non-key field depends on another non-key field. Every field depends on the key, the whole key and nothing but the key.