/en-tutor-prep-s6-ict-databases-sql-practice-3/
/en-tutor-prep-s6-ict-databases-sql-practice-3/
General Inquiry: info@TutorZone.com.hk
Office Hours: Monday to Saturday - 9:00 AM to 6:00 PM
WhatsApp Monday to Sunday - 24 hours
Hotline: +852 6828 1809
Instant Support: +852 9061 3106

S6 ICT Databases and SQL Practice (Paper 3: Challenge)

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)

  1. FoundationWhat does first normal form (1NF) require?
  2. FoundationWhich dependency does second normal form (2NF) remove?
  3. FoundationWhich dependency does third normal form (3NF) remove?
  4. FoundationA Mark table has four rows and two of them hold NULL. What does SELECT AVG(Mark) return?
  5. IntermediateOn the same table, what do SELECT COUNT(*) and COUNT(Mark) return?
  6. IntermediateDividing the total by all 4 rows instead of the 2 non-NULL rows gives what wrong answer?
  7. ChallengeGROUP BY Class gives 6A 3 rows, 6B 2 rows and 6C 4 rows. How many groups survive HAVING COUNT(*) > 2?
  8. ChallengeHow does a candidate key differ from a primary key?
  9. 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?
  10. 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.

Join as a tutor or coach — academic, music, sports, arts, STEM. Free to register. See how it works →