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)
- FoundationA column stores several phone numbers as an array. Which normal form does this break first?
- FoundationIn a composite key table, a non-key attribute depends on one key column only. Which normal form is violated?
- FoundationA non-key attribute depends on another non-key attribute. Which normal form is violated?
- FoundationWhat is the main purpose of normalisation?
- IntermediateDeletion, insertion and update anomalies share one cause. What is it?
- IntermediateA query joins three tables. What is the minimum number of join conditions?
- 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?
- ChallengeAfter normalisation a query reads three tables of 5,000 rows each. How many rows are scanned in total?
- Error redoSomeone says 2NF removes transitive dependencies. Is that correct?
- 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.



