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)
- FoundationWhat does first normal form (1NF) require of every cell?
- FoundationWhich dependency does second normal form (2NF) remove?
- FoundationWhich dependency does third normal form (3NF) remove?
- 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?
- IntermediateFor the same example, what percentage of the stored characters is saved?
- IntermediateWhat is the database term for the statement that StudentID determines Name and Class?
- Challenge22 enrolments over 12 courses gives 1.83 per course. What would an average below 1 mean?
- ChallengeAfter splitting a flat table into 4 tables, how many joins rebuild the full result?
- ChallengeThe flat table has 6 columns while the 4 new tables hold 9 column slots in total. What is the ratio?
- 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.



