WA Computer Science ATAR Unit 2 Word Scramble: Data Management and Cyber Security (Modules 28–122)
Name:
Date:
Class:
🔤
Word scramble
Unscramble the letters and write each key term on the line.
1
TAAD LMAYANO
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.
2
NUFLTANICO CPNDEDYNEE
A field is functionally dependent on another when the other field's value determines it. The determinant fixes the value: studentId determines studentName.
3
N1F
A table is in ______ when every field holds one atomic value, there are no repeating groups, and each record is identified by a key.
4
NF2
A table in 1NF where no non-key field depends on only part of a composite key. Remove any partial dependency by splitting those fields into a new table.
5
FN3
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.
6
IORLMESNA OT FN3
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.
7
SI ULNL
NULL marks a missing value. Test for it with ______ or IS NOT NULL, because = NULL never matches. NULL is not a blank or 0, and aggregates ignore it.
8
TIITEYRNG
Data stays accurate, complete and unaltered unless an authorised person changes it. Tampering breaks ______ by altering data without permission.
9
ILBAALTAIVIY
Authorised users can reach data and systems when they need them. Attacks like DDoS and hardware failure reduce it.
Answer Key
WA Computer Science ATAR Unit 2 · Modules 28–122
1TAAD LMAYANO → data anomaly — 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.
2NUFLTANICO CPNDEDYNEE → functional dependency — A field is functionally dependent on another when the other field's value determines it. The determinant fixes the value: studentId determines studentName.
3N1F → 1NF — A table is in 1NF when every field holds one atomic value, there are no repeating groups, and each record is identified by a key.
4NF2 → 2NF — A table in 1NF where no non-key field depends on only part of a composite key. Remove any partial dependency by splitting those fields into a new table.
5FN3 → 3NF — 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.
6IORLMESNA OT FN3 → Normalise to 3NF — 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.
7SI ULNL → IS NULL — NULL marks a missing value. Test for it with IS NULL or IS NOT NULL, because = NULL never matches. NULL is not a blank or 0, and aggregates ignore it.
8TIITEYRNG → integrity — Data stays accurate, complete and unaltered unless an authorised person changes it. Tampering breaks integrity by altering data without permission.
9ILBAALTAIVIY → Availability — Authorised users can reach data and systems when they need them. Attacks like DDoS and hardware failure reduce it.