/en-tutor-prep-s5-ict-database-normalisation-practice-4/
/en-tutor-prep-s5-ict-database-normalisation-practice-4/
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 4: Common mistakes corrected

Paper 4: Common mistakes corrected

  • 2026-11-21

Paper 4: Common mistakes corrected

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

Paper 4 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 Retry

02 Questions (10 items)

  1. FoundationDoes 1NF require one value per cell?
  2. FoundationShould a multi-value column be split into several columns or moved to a detail table?
  3. FoundationCan a primary key contain an empty value?
  4. FoundationCan each column of a composite key repeat?
  5. IntermediateHow do partial and transitive dependencies differ?
  6. IntermediateMust a table in 2NF also be in 1NF?
  7. ChallengeA table has eight attributes and two transitive dependencies. How many tables result after decomposition?
  8. ChallengeA detail table has 300 rows repeating a 20-character category name, with only 12 distinct categories. How many characters are saved after normalisation?
  9. Error redoMust a foreign key have the same name as the primary key it references?
  10. Error redoOnce normalised, may tables never be merged again?

03 Answers and one-line notes

# Answer One-line note
1 Yes, that is the core requirement of 1NF. Repeating groups and multi-value columns both break 1NF.
2 A detail table is better. A separate table can hold any number of values.
3 No. A primary key must identify every row uniquely.
4 Yes, but the combination must be unique. Uniqueness of the combination is the point of a composite key.
5 Depending on part of the key is partial, while depending on another non-key attribute is transitive. The first belongs to 2NF and the second to 3NF.
6 Yes, normal forms are reached step by step. 2NF is meaningless before 1NF is achieved.
7 Three tables. Each transitive dependency becomes a separate table.
8 5,760 characters are saved. The original cost was 6,000 characters and the normalised form uses 240.
9 No, only the data type and values must correspond. Matching names merely aid readability.
10 No, deliberate denormalisation is allowed for performance. Denormalisation accepts the risk of repeated storage.

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 →