S6 ICT Databases and SQL Practice (Paper 3: Challenge)
- 2026-11-17
S6 ICT Databases and SQL Practice (Paper 3: Challenge)
The three normal forms, the effect of NULL on averages, HAVING on groups, candidate keys and multi-table JOINs.
NULL is not zero Paper 3 tackles the concepts students lose marks on. 1NF wants atomic cells, 2NF removes partial dependency and 3NF removes transitive dependency. NULL handling matters most: with two of four rows NULL, AVG uses non-NULL values only, so 80 plus 90 over 2 gives 85, while dividing by 4 wrongly gives 42.5. COUNT(*) gives 4 but COUNT(Mark) gives 2. HAVING filters after grouping, so COUNT(*) > 2 keeps only 6A and 6C. A candidate key could identify a row uniquely; the primary key is the one actually chosen. The last two items note that a JOIN cannot exceed the Cartesian product and that 3NF data needs a JOIN to come back together.
01 Paper details (check answers afterwards)
| Item | Detail |
|---|---|
| Questions | 10 |
| Suggested time | 25 |
| Difficulty mix | Foundation 4 · Intermediate 2 · Challenge 2 · Error redo 2 |
| Chapter | Chapter: S6 ICT: Databases and SQL |
| Level | Challenge (S6 ICT) |
02 Questions (10 items)
- FoundationWhat does first normal form (1NF) require?
- FoundationWhich dependency does second normal form (2NF) remove?
- FoundationWhich dependency does third normal form (3NF) remove?
- FoundationA Mark table has four rows and two of them hold NULL. What does SELECT AVG(Mark) return?
- IntermediateOn the same table, what do SELECT COUNT(*) and COUNT(Mark) return?
- IntermediateDividing the total by all 4 rows instead of the 2 non-NULL rows gives what wrong answer?
- ChallengeGROUP BY Class gives 6A 3 rows, 6B 2 rows and 6C 4 rows. How many groups survive HAVING COUNT(*) > 2?
- ChallengeHow does a candidate key differ from a primary key?
- Error redoStudent has 4 rows and Mark has 3. SELECT * FROM Student, Mark gives 12 rows; after WHERE Student.ID = Mark.SID at most how many remain?
- Error redoA student says that after normalising to 3NF one table returns all the data. What is wrong?
03 Answers and one-line notes
| # | Answer | One-line note |
|---|---|---|
| 1 | Every cell holds one atomic value; no lists or multi-values. | A cell with several values makes querying and updating painful, so such data is split into rows. |
| 2 | Partial dependency, where a non-key column depends on only part of a composite key. | On top of 1NF, every non-key column must depend on the whole key. |
| 3 | Transitive dependency, where a non-key column depends on another non-key column. | For example Student ID gives Class and Class gives the form teacher, so the teacher belongs in another table. |
| 4 | 85. | AVG uses non-NULL values only: 80 plus 90 divided by 2 gives 85. |
| 5 | 4 and 2. | COUNT(*) counts 4 rows; COUNT(column) skips NULL and gives 2. |
| 6 | 42.5. | 170 divided by 4 is 42.5, the classic error of treating NULL as zero. |
| 7 | 2 groups. | HAVING filters after grouping, so only 6A with 3 and 6C with 4 pass. |
| 8 | A candidate key is any key that could identify a row uniquely; the primary key is the one chosen. | A table may have several candidate keys but only one primary key. |
| 9 | At most 12. | WHERE can only reduce rows; it never exceeds the Cartesian product. |
| 10 | Wrong. 3NF spreads data across several tables, so a JOIN is needed to get the full picture. | Normalisation removes duplication and anomalies at the cost of multi-table JOINs; one table is not enough. |
04 What to do after marking
- After marking, redo only the wrong items and write down which step went wrong (formula, unit, or misread number).
- Repeat the same item two days later; move to the next paper only when both attempts are correct.
- Parents only need the answer and note columns; there is no need to explain every item.
After paper 3, revisit the normalisation examples on the chapter page, then use paper 4 to retry the common COUNT and sorting mistakes.Tutor Registration →
Questions and answers are written originally by the TutorZone team and are not taken from any school, publisher or examination authority paper. Every value is checked by computer.



