praxis.ibLog in
A3.2 Database designA3.2.6

Constructing a database normalized to 3NF

Construct a database normalized to 3NF for a range of real-world scenarios

SL + HL≈ 60 minCommand term: ConstructPremium

In this lesson

  • A step-by-step method for taking a real-world data set to 3NF
  • How to find the functional dependencies in a scenario
  • Checking a design: keys, links, and no lost data

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. LearnA method that always works
  2. LearnWorked through: a warehouse
  3. CheckIn what order?
  4. LabNormalise a bike hire shop
  5. ExamWorked exam answer
  6. ReviewMistakes examiners see
  7. Exam practiceExam-style questions

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