SHSubjectHub

Project: Design & Query a Database

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.

  • 11 questions
  • 35 marks
  • about 50 minutes
  • marked instantly

Question types: short answer, multiple choice, true or false, fill the gap, crossword.

Try it with a class, freeHow it works

Try one from this worksheet

A garden centre is designing a database. Which of these should be stored as an ENTITY (its own table), rather than as an attribute (a column)?

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

About this resource

KS3 Databases (Lesson 6 of 6) — the capstone project and the final lesson of KS3 computing. Pupils PLAN a small database for an animal rescue centre (entities, attributes, keys), DESIGN it with the ER-diagram tool, BUILD real tables in the Spreadsheet Lab, write SQL QUERIES to answer real questio…

19 slides.

Lesson outline

  1. Hook — Every App Runs On This
  2. Do Now — SQL & the Whole Unit (Recap)
  3. Key Words for Today
  4. Quick Check — What Is a Record?
  5. The Project — Willow Animal Rescue
  6. Your Success Criteria
  7. Stage 1 — PLAN
  8. PLAN — Identify Entities, Attributes & Keys
  9. Hinge Check — Entity or Attribute?
  10. Stage 2 — DESIGN
  11. DESIGN — Set the Relationships
  12. Stage 3 — BUILD SPRINT: Build Your Tables for Real
Unit bundleDatabases
Part of: Databases: the whole unitEvery resource in the unit in one zip.

More from Databases