praxis.ibLog in
A3.2 Database designA3.2.2

Construct ERDs

Construct ERDs

SL + HL≈ 50 minCommand term: ConstructPremium

In this lesson

  • Why entity relationship diagrams matter when designing a database
  • How to show entities and the relationships between them
  • The roles of cardinality and modality, and how to draw them in crow's foot notation

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. LearnEntity relationship diagrams
  2. LearnCrow's foot notation
  3. CheckQuick check
  4. LabBuild the ERD for a music school
  5. LearnFrom scenario to ERD, and from M:N to tables
  6. ExamWorked exam answer
  7. ReviewMistakes examiners see
  8. Exam practiceExam-style questions

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