/en-tutor-prep-s6-ict-database-design-er-normalisation-practice-2/
/en-tutor-prep-s6-ict-database-design-er-normalisation-practice-2/
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: the three normal forms and redundancy

S6 ICT: the three normal forms and redundancy

  • 2026-11-20

S6 ICT: the three normal forms and redundancy

From 1NF to 3NF, checking partial and transitive dependency and the storage change after splitting.

Intermediate: the three normal forms This paper concentrates on the 1NF to 3NF tests. It covers one atomic value per cell, partial dependency as a composite key problem, and transitive dependency as the 3NF target. Numbers follow: 12 courses each repeat a 15 character teacher name, 180 characters in all, dropping to 75 characters after the split, a saving of 105 characters or 58.33 percent. It closes with 1.83 enrolments per course and 3 joins to rebuild 4 tables.

01 Paper details (check answers afterwards)

Item Detail
Questions 10
Suggested time 25
Difficulty mix Foundation 3 · Intermediate 3 · Challenge 3 · Error redo 1
Chapter Chapter: S6 ICT: Database Design and the ER Model
Level Intermediate (10 items)

02 Questions (10 items)

  1. FoundationWhat does first normal form (1NF) require of every cell?
  2. FoundationWhich dependency does second normal form (2NF) remove?
  3. FoundationWhich dependency does third normal form (3NF) remove?
  4. Intermediate12 courses each store a 15 character teacher name, giving 180 characters. After splitting out a teacher table only 5 rows remain, 75 characters. How many characters are saved?
  5. IntermediateFor the same example, what percentage of the stored characters is saved?
  6. IntermediateWhat is the database term for the statement that StudentID determines Name and Class?
  7. Challenge22 enrolments over 12 courses gives 1.83 per course. What would an average below 1 mean?
  8. ChallengeAfter splitting a flat table into 4 tables, how many joins rebuild the full result?
  9. ChallengeThe flat table has 6 columns while the 4 new tables hold 9 column slots in total. What is the ratio?
  10. Error redoA student says 3NF still allows transitive dependency. Where is the error?

03 Answers and one-line notes

# Answer One-line note
1 One atomic value per cell, with no repeating groups. A cell holding many values forces string splitting on every query and defeats the point of a relation.
2 Partial dependency, where a non-key column depends on only part of a composite key. Partial dependency needs a composite key, so a single column key is always in 2NF.
3 Transitive dependency between non-key columns. CourseID determines TeacherID and TeacherID determines the teacher name, which is a transitive dependency.
4 105 characters are saved. 180 minus 75 is 105.
5 About 58.33 percent. 105 divided by 180 is 0.5833.
6 A functional dependency. One StudentID maps to exactly one pair of Name and Class values.
7 It means at least one course has no students at all. Anything below 1 forces some courses to hold 0 while others make up the total.
8 3 joins are needed. Joining n tables takes n minus 1 joins.
9 The ratio is 1.5. 9 divided by 6 is 1.5, because keys repeat in each table.
10 3NF exists to remove transitive dependency; 2NF is the form that still allows it. 2NF only removes partial dependency, leaving transitive dependency for 3NF.

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 to draw the flowchart and fill the trace table yourself? Book a TutorZone tutor and unpack all ten items in 25 minutes.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 →