to look for specific data in a database by using a rule

Database search

British English CC

Database search and sort

Using a database

Computing

Creating a paper-based database

Computer databases

Using search tools

Comparing data visually

Databases in real life

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.

Flat-file databases

displays only the records that match a condition

Answers specific questions by using grouping and sorting together

What is an example of a criterion for sorting data?

How can grouping and sorting be combined?

Arrange the steps for grouping and sorting data to answer a question:

All data is deleted except the matching records.

Only matching records are shown, but the database is not changed.

What happens to the database when you perform a search?

What is a category of data in each record of a database called?

a way of presenting data that has been sorted and organised

a database that stores data in a single table

A field contains all data about one item, while a record is a category of data.

A field stores data in multiple tables, while a record stores data in a table.

A field is a category of data, while a record contains all data about one item.

What is the difference between a field and a record?

What is the process of arranging data in a specific order in a database called?

to make data easier to find and understand

Why is it useful to sort data in a database?

This lesson was made for home learning during the pandemic.

Using a database

Lesson outcome

This lesson was made for home learning during the pandemic.