SHSubjectHub

Tables, Records & Fields

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.

  • 12 questions
  • 35 marks
  • about 40 minutes
  • marked instantly

Question types: multiple choice, multi-part, crossword, label the diagram, matching.

Try it with a class, freeHow it works

Try one from this worksheet

A field records whether a pupil has paid for a school trip — the answer is only ever Yes or No. Which data type is the best choice for this field?

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

About this resource

Go inside a database table: the data types a field can hold (text, number, date and Boolean), the primary key that gives every record a unique id, and how to design a good table by choosing the right fields and the right types.

15 slides.

Lesson outline

  1. Hook — Two Pupils, Same Name
  2. Do Now — Recall from Lesson 1
  3. Record — One Row, One Real Thing
  4. Hinge Check — Record or Field?
  5. Field Data Types
  6. Quick Check — Which Data Type?
  7. Task 1 (guided) — Sort the Fields by Data Type
  8. The Primary Key — A Unique ID
  9. Check — A Bad Primary Key
  10. Designing a Good Table
  11. Task 2 (semi-guided) — True or False?
  12. Main Task (independent) — Design the Book Table
Unit bundleDatabases
Part of: Databases: the whole unitEvery resource in the unit in one zip.

More from Databases