Year 3 - Computing
Structuring a branching database
Organising data using databases
Study Hub
Study Guides
This pupil-friendly study guide includes a unit summary, clear notes, common mistakes, and quick questions with answers.
Unit Summary
This unit develops pupils' knowledge of what a branching database is and how to create one. They will use yes/no questions to gain an understanding of what attributes are and how to use them to sort groups of objects. Pupils will create an identification tool using a branching database.
Lesson Summary
You will learn to explain why it is helpful for a database to be well structured.
Key Notes
- 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.
Vocabulary To Learn
- order: the way things are arranged in a sequence
- structure: the way related parts are organised
Common Mistakes To Avoid
- Only the first question matters when you are thinking about ordering the questions in your branching database.
3 Quick Questions (With Answers)
1. Describe the system or process from this lesson in clear steps.
It is helpful to have well structured data. Two database structures can be compared.
2. Define this computing term and give one practical example. 'order'
the way things are arranged in a sequence. Add one real device or system example to prove understanding.
3. Correct this common computing misconception.
Mistake: Only the first question matters when you are thinking about ordering the questions in your branching database. Correction: 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.
More Lessons In This Unit
Browse all guides in the Year 3 Computing guide library.