QCE Digital Solutions Unit 2 Definitions Worksheet: Data and Programming Techniques (Modules 234–285)
Name:
Date:
Class:
✎
Key terms
Write what each term means, in your own words.
1
Table(PK, field, FK)
2
normalisation
3
First normal form (1NF)
4
2NF
5
3NF
6
1NF, 2NF, 3NF
7
if valid = true then
8
for each line in file
9
repeat ... until choice = 4
10
for each record in results
Answer Key
QCE Digital Solutions Unit 2 · Modules 234–285 · Student wording will vary for definitions
1Table(PK, field, FK) — A relational schema lists each table and its fields, marks the primary key (underlined) and foreign keys (FK), and shows how tables link.
2normalisation — Organising tables to reduce repeated data and prevent anomalies by splitting data into linked tables, using the normal forms 1NF to 3NF.
3First normal form (1NF) — A table is in 1NF when every field holds one atomic value, there are no repeating groups or repeating columns, and each row is identified by a key.
42NF — Second normal form: the table is in 1NF and every non-key field depends on the WHOLE primary key, so no field depends on only part of a composite key. Move partial fields to their own table.
53NF — Third normal form: the table is in 2NF and no non-key field depends on another non-key field (no transitive dependency), e.g. suburb depends on postcode, so move it to its own table.
61NF, 2NF, 3NF — Work through 1NF, 2NF, then 3NF, splitting data into new tables linked by foreign keys so no data is lost and anomalies are removed.
7if valid = true then — Only insert the record if every validation check left the valid flag true. If any check set valid to false, skip the bad record or report it instead of inserting it.
8for each line in file — A loop that reads each line, splits it into fields, trims and validates them, then builds an INSERT statement for each good row and counts accepted and rejected rows.
9repeat ... until choice = 4 — A menu loop: repeat shows the menu, reads the choice, picks an action with if or else if, and stops on the exit choice. Any other value gets an invalid choice message.
10for each record in results — 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 results message.