Structuring a branching database
Lesson details
Learning outcome
I can explain why it is helpful for a database to be well structured.
Key learning points
- It is helpful to have well structured data.
- Two database structures can be compared.
- The order in which questions are asked needs to be considered carefully.
Keywords
Order - the way things are arranged in a sequence
Structure - the way related parts are organised
Common misconception
Only the first question matters when you are thinking about ordering the questions in your branching database.
The first question is really important but you also need to think carefully about the order of the other questions so that the branching database works properly and all objects can be identified.
Teacher tip
Consider if the examples in the lesson could be better adapted to meet the interests of the pupils you teach. Pupils will grasp concepts more quickly if they better understand the objects they are comparing.
Equipment
Pupils will need access to a device with software that can create branching databases. Examples in this lesson use J2E branch https://oak.link/branching-db
Licence
Lesson video
Loading...
Prior knowledge starter quiz
6 Questions
Q1.What does a branching database help you do?
Q2.Which of these is an example of a well-structured diagram?
Q3.Why is it important to test a branching database?
Q4.Which of these is NOT something that involves a branching database?
Q5.What is the first step in creating a branching database?
Q6.What happens if a database is not well-structured?
Assessment exit quiz
6 Questions
Q1.What is the main purpose of a branching database?
Q2.What is the role of the first question in a branching database?
Q3.Put these steps in order for creating a branching database:
Q4.Why is it important to think about the order of all questions in a branching database?
Q5.How can you improve a branching database?
Q6.Match each term with its definition or function:
the way objects are arranged in a sequence
the way related parts are organised
ensuring that the database works correctly
divides objects into two main groups
To help you plan your 3 computing lesson on: Structuring a branching database, download all teaching resources for free and adapt to suit your pupils' needs...
To help you plan your 3 computing lesson on: Structuring a branching database, download all teaching resources for free and adapt to suit your pupils' needs.
The starter quiz will activate and check your pupils' prior knowledge, with versions available both with and without answers in PDF format.
We use learning cycles to break down learning into key concepts or ideas linked to the learning outcome. Each learning cycle features explanations with checks for understanding and practice tasks with feedback. All of this is found in our slide decks, ready for you to download and edit. The practice tasks are also available as printable worksheets and some lessons have additional materials with extra material you might need for teaching the lesson.
The assessment exit quiz will test your pupils' understanding of the key learning points.
Our video is a tool for planning, showing how other teachers might teach the lesson, offering helpful tips, modelled explanations and inspiration for your own delivery in the classroom. Plus, you can set it as homework or revision for pupils and keep their learning on track by sharing an online pupil version of this lesson.
Explore more key stage 2 computing lessons from the Organising data using databases unit, dive into the full primary computing curriculum, or learn more about lesson planning.