SHSubjectHub

Linking Tables: Relationships

KS3Lesson packSubscription
Also online

This worksheet marks itself

Set it as homework or classwork and every answer is marked as pupils go, with feedback on what they got wrong. The scores go straight into your mark book, so you can see who needs help before the next lesson.

  • 10 questions
  • 35 marks
  • about 45 minutes
  • marked instantly

Question types: wordsearch, multiple choice, matching, label the diagram, sorting.

Try it with a class, freeHow it works

Try one from this worksheet

A gym stores everything in ONE big table, repeating each trainer's phone number on every member's row. What is the MAIN problem this causes?

Pick an answer: it's marked straight away, just as your pupils would see it.

About this resource

KS3 Databases (Lesson 4 of 6). Why cramming everything into one big table causes repeated data and mistakes; splitting data into related tables; entities; a simple one-to-many relationship; primary keys and foreign keys in kid-friendly terms. Uses the ER-diagram tool to set the cardinality of a o…

17 slides.

Lesson outline

  1. Hook — 90
  2. Do Now — Retrieval
  3. Key Words for Today
  4. The Problem: One Giant Table
  5. Quick Check — Is Repeating Data OK?
  6. The Fix: Split Into Related Tables
  7. What Counts as an Entity?
  8. Primary Keys and Foreign Keys
  9. Task 1 (guided) — Sort: Primary Key or Foreign Key?
  10. Hinge Check — Which Table Does the Foreign Key Go In?
  11. One-to-Many Relationships
  12. We Do — Set the Relationship (Tutor Groups & Pupils)
Unit bundleDatabases
Part of: Databases: the whole unitEvery resource in the unit in one zip.

More from Databases