Computer Science — Boolean Logic and Relational Databases

Exam board: Edexcel  |  Back to subjects

Board-Specific Note

Edexcel (Pearson) specification; check the specific content list for your paper.

Learning Objectives

• Use logic gates
• Normalise databases
• Query with SQL

Key Points

• AND, OR, NOT gates
• Entities, attributes, primary keys
• SELECT, FROM, WHERE

Lesson Plan (50 minutes)

1. Starter (5 min): Recall prior knowledge of boolean logic and relational databases with quick questions.
2. Teaching (15 min): Work through each of the learning objectives, explaining principles step by step.
3. Key points review (5 min): Revisit the key points together, confirming understanding.
4. Worked example (10 min): Model the example question: Output of AND gate with inputs 1 and 0?. Solution: 0
5. Practice (10 min): Students attempt the practice questions independently; circulate and support.
6. Plenary (5 min): Review answers and address misconceptions.

Homework

• Draw a truth table for OR
• Define a primary key
• Write a basic SQL SELECT query

Assessment

Check practice answers against the model answer; use the built-in practice questions as formative assessment.