Paper 4: Common mistakes corrected
Chapter practice with ten items, answers and a one-line note for each, about 25 minutes.
| Item | Detail |
|---|---|
| Questions | 10 |
| Suggested time | 25 |
| Difficulty mix | Foundation 4 · Intermediate 2 · Challenge 2 · Error redo 2 |
| Chapter | Chapter: Database normalisation |
| Level | Retry |
| # | 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. |
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.

