/en-tutor-prep-s5-ict-database-normalisation-practice-1/
/en-tutor-prep-s5-ict-database-normalisation-practice-1/
General Inquiry: info@TutorZone.com.hk
Office Hours: Monday to Saturday - 9:00 AM to 6:00 PM
WhatsApp Monday to Sunday - 24 hours
Hotline: +852 6828 1809
Instant Support: +852 9061 3106

Paper 1: Normal form basics

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)

  1. FoundationWhat does first normal form require of each column value?
  2. FoundationA cell holds three values, Chinese, English and Maths. Is the table in 1NF?
  3. FoundationWhat is the purpose of a primary key?
  4. FoundationAn order detail table uses order number plus product code as its key. How many attributes form that key?
  5. IntermediateA table has six attributes and one of them stores multiple values. What is the minimum number of tables after reaching 1NF?
  6. IntermediateIn a composite key table, a non-key attribute depends on only part of the key. Which normal form is violated?
  7. ChallengeAn employee table stores department code and department name, and the name depends only on the code. What problem is this?
  8. ChallengeAn order table has 40 rows, each repeating the same department name. Before normalisation, how many rows must change for a rename?
  9. Error redoSomeone says 2NF requires every non-key attribute to depend on the primary key. What is missing?
  10. 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.

Join as a tutor or coach — academic, music, sports, arts, STEM. Free to register. See how it works →