GCSE Computer Science -Understanding database relationships

Building on from knowledge of flat file databases, tables, fields, records, this lesson guides the learners on a journey into foreign keys, relationship types (one to many, many to many, one to one) They are given fields names at first to rearrange into two tables for one to many, learning the concept of how we decide upon the relationship to use. This builds further into recognising where to use a foreign key. The knowledge is expanded upon with the introduction of many to many relationships, and the concept of link, or junction tables. Learners then have the opportunity to test their knowledge. Answer slides are given. This was observed and judged to be engaging, and showed excellent progress. Everybody needs a bit of that!