/en-tutor-prep-s5-ict-database-normalisation-practice-3/
/en-tutor-prep-s5-ict-database-normalisation-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

Paper 3: Decomposition and cost

Paper 3: Decomposition and cost

  • 2026-11-21

Paper 3: Decomposition and cost

Chapter practice with ten items, answers and a one-line note for each, about 25 minutes.

Paper 3 Ten items on this chapter with answers for immediate marking.

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: Database normalisation
Level Challenge

02 Questions (10 items)

  1. FoundationA column stores several phone numbers as an array. Which normal form does this break first?
  2. FoundationIn a composite key table, a non-key attribute depends on one key column only. Which normal form is violated?
  3. FoundationA non-key attribute depends on another non-key attribute. Which normal form is violated?
  4. FoundationWhat is the main purpose of normalisation?
  5. IntermediateDeletion, insertion and update anomalies share one cause. What is it?
  6. IntermediateA query joins three tables. What is the minimum number of join conditions?
  7. ChallengeA log table has 5,000 rows repeating a 30-character status text, but only 20 distinct statuses exist. How many characters are saved by moving statuses to their own table?
  8. ChallengeAfter normalisation a query reads three tables of 5,000 rows each. How many rows are scanned in total?
  9. Error redoSomeone says 2NF removes transitive dependencies. Is that correct?
  10. Error redoDoes normalisation always make queries faster?

03 Answers and one-line notes

# Answer One-line note
1 First normal form. 1NF requires one value per cell.
2 Second normal form. A partial dependency is exactly what 2NF deals with.
3 Third normal form. This situation is a transitive dependency.
4 To cut repeated storage and update anomalies so data stays consistent. It also makes the data structure clearer.
5 The same fact is stored in several places. Changing one copy and missing another produces inconsistency.
6 Two. Each extra table adds one more join condition.
7 149,400 characters are saved. The original cost was 150,000 characters and the split form uses 600.
8 15,000 rows. Consistency from splitting costs extra scanning.
9 No, removing transitive dependencies belongs to 3NF. 2NF deals with partial dependencies.
10 No, joins across many tables can slow queries down. Deliberate denormalisation can be used when speed matters.

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.

Want the whole chapter? See all four difficulty papers on the chapter page.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 →