praxis.ibLog in
A3.2 Database designA3.2.5

Difference between normal forms

Explain the difference between normal forms

SL + HL≈ 55 minCommand term: ExplainPremium

In this lesson

  • Atomicity, unique identification and functional dependencies
  • Partial key dependencies and non-key (transitive) dependencies
  • What first, second and third normal form each require, and the problems each one removes

This lesson is part of Premium

Every topic has one free lesson. Premium unlocks every interactive lesson, the exam-style questions at the end of each one, and the rest of Praxis IB.

Log in or sign upTry the free lesson: A3.2.1 Database schema

What's inside

  1. LearnThe ideas behind normalisation
  2. CheckQuick check
  3. Learn1NF, 2NF and 3NF
  4. LabOne order form, four stages
  5. CheckWhat kind of dependency?
  6. LearnWhat normalisation fixes
  7. ExamWorked exam answer
  8. ReviewMistakes examiners see
  9. Exam practiceExam-style questions

Ends with 5 exam-style questions worth 12 marks, with a self-marking markscheme.