QCE Digital Solutions Unit 2 Word Scramble: Data and Programming Techniques (Modules 144–185)
Name:
Date:
Class:
🔤
Word scramble
Unscramble the letters and write each key term on the line.
1
ROMAFPTL UNMTEIREEQR
A requirement stating the operating system, device type or environment (desktop, web, mobile, database software) that the solution must run on.
2
RADHEARW IREQMREUENT
The processing power, memory, storage and peripherals needed to run a solution and hold its data, such as disk space for a database or RAM for large files.
3
ATDA IOQTIISUANC
Capturing data from a source and bringing it into a solution in a usable form: choose the source, capture it accurately, then check it on arrival.
4
ATAD LCSENTEOPMSE
Data is complete when every required value is present, with no missing fields or records. A presence check finds blank required fields.
5
AADT EYCNTISCONS
The same fact has the same value and format everywhere it is stored, with no spelling variations or conflicting copies. Storing each fact in one place helps keep it consistent.
6
ROIETISNN YANALOM
A problem where a new fact, like a new course, cannot be stored until unrelated data, like a student, exists, forcing null values or dummy rows in a single table.
7
ETADUP LAYOAMN
A problem where a repeated fact is changed in one row but not its other copies, so the data disagrees. Caused by redundancy, and fixed by normalisation.
8
OENLDITE LOMYAAN
Deleting a row also wipes out a separate fact stored only in that row, e.g. deleting the last student enrolled in a course also erases the course details.
9
TGENYITIR
Data stays accurate and unaltered unless an authorised person changes it, so a tampered bank balance breaks ______.
Answer Key
QCE Digital Solutions Unit 2 · Modules 144–185
1ROMAFPTL UNMTEIREEQR → platform requirement — A requirement stating the operating system, device type or environment (desktop, web, mobile, database software) that the solution must run on.
2RADHEARW IREQMREUENT → hardware requirement — The processing power, memory, storage and peripherals needed to run a solution and hold its data, such as disk space for a database or RAM for large files.
3ATDA IOQTIISUANC → data acquisition — Capturing data from a source and bringing it into a solution in a usable form: choose the source, capture it accurately, then check it on arrival.
4ATAD LCSENTEOPMSE → data completeness — Data is complete when every required value is present, with no missing fields or records. A presence check finds blank required fields.
5AADT EYCNTISCONS → data consistency — The same fact has the same value and format everywhere it is stored, with no spelling variations or conflicting copies. Storing each fact in one place helps keep it consistent.
6ROIETISNN YANALOM → insertion anomaly — A problem where a new fact, like a new course, cannot be stored until unrelated data, like a student, exists, forcing null values or dummy rows in a single table.
7ETADUP LAYOAMN → update anomaly — A problem where a repeated fact is changed in one row but not its other copies, so the data disagrees. Caused by redundancy, and fixed by normalisation.
8OENLDITE LOMYAAN → deletion anomaly — Deleting a row also wipes out a separate fact stored only in that row, e.g. deleting the last student enrolled in a course also erases the course details.
9TGENYITIR → Integrity — Data stays accurate and unaltered unless an authorised person changes it, so a tampered bank balance breaks integrity.