Paper 1: Normal form basics
- 2026-11-21
Paper 1: Normal form basics
Chapter practice with ten items, answers and a one-line note for each, about 25 minutes.
Paper 1 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 | Basic |
02 Questions (10 items)
- FoundationWhat does first normal form require of each column value?
- FoundationA cell holds three values, Chinese, English and Maths. Is the table in 1NF?
- FoundationWhat is the purpose of a primary key?
- FoundationAn order detail table uses order number plus product code as its key. How many attributes form that key?
- IntermediateA table has six attributes and one of them stores multiple values. What is the minimum number of tables after reaching 1NF?
- IntermediateIn a composite key table, a non-key attribute depends on only part of the key. Which normal form is violated?
- ChallengeAn employee table stores department code and department name, and the name depends only on the code. What problem is this?
- ChallengeAn order table has 40 rows, each repeating the same department name. Before normalisation, how many rows must change for a rename?
- Error redoSomeone says 2NF requires every non-key attribute to depend on the primary key. What is missing?
- Error redoDo all tables in 3NF have no repeated data at all?
03 Answers and one-line notes
| # | Answer | One-line note |
|---|---|---|
| 1 | Each value must be a single atomic value, with no multi-value or repeating group. | Packing several values into one cell breaks 1NF. |
| 2 | No, that cell holds three values. | A multi-value column must be split into separate columns or moved to a detail table. |
| 3 | To identify each row of the table uniquely. | Primary key values are unique and never empty. |
| 4 | Two attributes, which makes it a composite key. | When one attribute cannot identify a detail row alone, a composite key is needed. |
| 5 | Two tables: the main table keeps five attributes and the detail table needs at least two. | Move the multi-value attribute to a detail table and keep only single values in the main table. |
| 6 | Second normal form. | This situation is called a partial dependency. |
| 7 | A transitive dependency, which violates third normal form. | Move the department data into a department table to reach 3NF. |
| 8 | Forty rows, while only one row changes after normalisation. | Repeated storage is the source of update anomalies. |
| 9 | 2NF requires full dependency on the whole composite key, not on just part of it. | Depending on only part of the key is a partial dependency. |
| 10 | No, 3NF removes transitive dependencies only, so other repetition can remain. | 3NF is necessary but does not guarantee zero redundancy. |
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.



