/en-tutor-prep-s5-ict-database-normalisation-practice-2/
/en-tutor-prep-s5-ict-database-normalisation-practice-2/
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 2: Normal forms checked

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)

  1. 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?
  2. FoundationIn that table the name depends only on the student id. What problem is this?
  3. FoundationThe table is split into student, subject and mark tables. How many attributes does each have?
  4. FoundationHow many foreign keys does the mark table need?
  5. IntermediateWhat is a transitive dependency?
  6. 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?
  7. ChallengeA table has nine attributes containing two independent transitive dependencies. What is the minimum number of tables after decomposition?
  8. 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?
  9. Error redoDoes a table in 3NF always satisfy BCNF?
  10. 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.

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