Paper 2: Normal forms checked
- 2026-11-21
Paper 2: Normal forms checked
Chapter practice with ten items, answers and a one-line note for each, about 25 minutes.
Paper 2 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 | Advanced |
02 Questions (10 items)
- FoundationA table holds student id, subject code, name, subject name and mark, keyed by student id plus subject code. How many non-key attributes are there?
- FoundationIn that table the name depends only on the student id. What problem is this?
- FoundationThe table is split into student, subject and mark tables. How many attributes does each have?
- FoundationHow many foreign keys does the mark table need?
- IntermediateWhat is a transitive dependency?
- IntermediateAn employee table stores employee id, department code and department name. Which normal form is violated and into how many tables should it be split?
- ChallengeA table has nine attributes containing two independent transitive dependencies. What is the minimum number of tables after decomposition?
- ChallengeAn order table has 200 rows, each repeating a 12-character department name, and the department table has only five departments. How many characters are saved?
- Error redoDoes a table in 3NF always satisfy BCNF?
- Error redoIs splitting into more tables always better?
03 Answers and one-line notes
| # | Answer | One-line note |
|---|---|---|
| 1 | Three: name, subject name and mark. | The key takes two columns and the other three are non-key attributes. |
| 2 | A partial dependency, so the table is not in 2NF. | The name should move to a student table keyed by student id. |
| 3 | Student two, subject two and mark three. | The mark table keeps the two key columns plus the score. |
| 4 | Two: student id and subject code. | Foreign keys point at the primary keys of the other two tables. |
| 5 | A non-key attribute depends on another non-key attribute and only indirectly on the key. | Removing the intermediate attribute removes the transitive dependency. |
| 6 | Third normal form is violated, and it should become two tables. | Keep the department code in the employee table and move the name to a department table. |
| 7 | Three tables. | Each transitive dependency becomes its own table, plus the original main table. |
| 8 | 2,340 characters are saved. | The original cost was 2,400 characters and the normalised form uses 60. |
| 9 | No, the two conditions differ. | BCNF places a stricter requirement on every determinant. |
| 10 | No, too many tables raise join costs. | Normalisation must balance integrity against query performance. |
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.



