praxis.ibLog in
A3.2 Database designA3.2.4

Construct tables for relational databases

Construct tables for relational databases

SL + HL≈ 50 minCommand term: ConstructPremium

In this lesson

  • How to write a table definition with its fields, data types and keys
  • How primary, foreign, composite and concatenated keys link tables
  • How well-defined tables protect data integrity, including what happens when linked rows are deleted or changed

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. LearnWriting a table
  2. CheckQuick check
  3. LearnKinds of key
  4. LearnWell-defined tables and data integrity
  5. LabDelete a customer with orders
  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.