Unit at a glance
6 lessons, 270 minutes of teaching
Scheme of work
The lessons in order
| Ref | Lesson pack | Structure | Worksheet | Quiz | Lab tab |
|---|---|---|---|---|---|
| 8.1 | Relational databases and keys A school that keeps a separate file for the library, the exams office and the sports department soon has three different addresses for the same student. | Think-Pair-Share | 6 Q, 19 marks | 6 MCQ | tab 4 |
| 8.1 | Entity-relationship diagrams Before anyone creates a table, a database designer sketches the entities and how they are related. | Mix-Pair-Share | 6 Q, 16 marks | 6 MCQ | tab 4 |
| 8.1 | Normalisation to third normal form A spreadsheet of students, tutors and courses looks fine until a tutor changes name and you have to edit forty rows. | Jigsaw | 6 Q, 18 marks | 6 MCQ | tab 5 |
| 8.2 | Database management systems Nobody reads or writes the tables of a large database directly. | Corners | 6 Q, 18 marks | 6 MCQ | none |
| 8.3 | SQL data definition language Before a single record can be stored, the database and its tables have to exist, with every field given a name and a data type, and the keys that link the tables declared. | Frayer Model | 6 Q, 17 marks | 6 MCQ | tab 6 |
| 8.3 | SQL data manipulation language With the tables built, SQL's data manipulation language does the daily work: totals and averages per group, questions that need two linked tables at once, and the inserts, updates and deletes that keep the data current. | Connect-Extend-Challenge | 6 Q, 20 marks | 6 MCQ | tab 4, tab 6 |
Each pack holds the plan, worksheet and quiz for its lesson. Teach the rows in order; the lab tabs match the student lessons.
Also for this topic