Year 5 - Computing
Computer databases
Flat-file 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 looks at how a flat-file database can be used to organise data. Pupils will use tools to order and answer questions about data. They will create graphs and charts from their data to solve problems. They will use a real-life database to answer a question, and present their work to others.
Lesson Summary
You will learn to navigate and sort data in a computer-based database using different views.
Key Notes
- Data can be stored in fields.
- Flat-file databases can display information in different ways.
- Each record in a database holds all of the data about one item.
Vocabulary To Learn
- field: a category of data in each record
- view: a way of presenting data that has been sorted and organised
Common Mistakes To Avoid
- You must look through every record individually to find an answer.
3 Quick Questions (With Answers)
1. Describe the system or process from this lesson in clear steps.
Data can be stored in fields. Flat-file databases can display information in different ways.
2. Define this computing term and give one practical example. 'field'
a category of data in each record. Add one real device or system example to prove understanding.
3. Correct this common computing misconception.
Mistake: You must look through every record individually to find an answer. Correction: Sorting a computer database by fields allows you to quickly find answers without checking each record one at a time.
More Lessons In This Unit
Browse all guides in the Year 5 Computing guide library.