KS2 Databases | How they Store Electronic Information

Back to ICT

ICT Quiz - Databases (Questions)

Discover how databases store information neatly. KS2 pupils practise fields and records, plus sorting and searching so you can find the right facts quickly and accurately.

Explore the Topic →

(quiz starts below)

Fascinating Fact:

Databases can sort information, for example, putting names in alphabetical order. Sorting helps you spot patterns and compare records.

In KS2 ICT, pupils learn how a database stores lots of information in an organised way. You can add data, search for what you need, and sort it to answer questions, like finding the oldest book or the most popular choice.

Key Terms

Database: A place on a computer where information is stored and organised.
Record: One complete set of information about something, such as one child or one book.
Field: A heading in a database, like “Name” or “Age”, where one type of information is stored.

Frequently Asked Questions (Click to see answers)

What is a database in KS2 ICT?

A database in KS2 ICT is a way to store information in an organised table, so you can add data and find it again using search, sort, or filters.

What is the difference between a field and a record?

A field is a category like “Colour” or “Price”. A record is one full row that contains all the fields for one item, such as one product or one person.

How does sorting help when using a database?

Sorting puts data into order, such as A to Z or smallest to largest, so it is easier to compare information and quickly find the highest, lowest, or next item.

Try These Related Quizzes

Which of the following types of information could you store in a database?

[ ]	Information about different products, including descriptions and prices
[ ]	Information about all of the pupils in a school, including name, date of birth and address
[ ]	Information about different countries, including population, climate and language
[ ]	All of the above

In a database about planets, all of the information about Mars would be held on what?

[ ]	A field
[ ]	A report
[ ]	A record
[ ]	A graph

Each record on a database has several different what?

[ ]	Different fields
[ ]	Different yards
[ ]	Different graphs
[ ]	Different coordinates

What is a database search called?

[ ]	A quest
[ ]	A query
[ ]	An inquest
[ ]	An answer

Imagine an animal database in which each record has these fields: number of legs, habitat, lifespan, diet. Which of the following pieces of information could NOT be found out from the database?

[ ]	Whether the animal is a reptile
[ ]	Whether the animal inhabits grassland
[ ]	Whether the animal eats mice
[ ]	Whether the animal has four legs

Which database might you use to help you find your next library book?

[ ]	An encyclopedia
[ ]	A journal
[ ]	A magazine
[ ]	A catalogue

Which fields would you expect to find in a database of library books?

[ ]	Author, title, whether your best friend liked the book
[ ]	Author, title, colour of cover, book condition, how long it will take to read
[ ]	Author, title, genre, number of pages, location
[ ]	Author and title only

If you had a database for the children in your class and you wanted to organise the list of children by date of birth, you would instruct the database to do what?

[ ]	Sort
[ ]	Randomise
[ ]	Alphabetise
[ ]	Save

A planet database could be organised in which of the following ways?

[ ]	By distance from the sun, in ascending numerical order
[ ]	By distance from the sun, in alphabetical order
[ ]	By time taken to orbit, in alphabetical order
[ ]	All of the above

10.

What is another name for the information held in a database?

[ ]	IQ
[ ]	Data
[ ]	Snippets
[ ]	Fun facts

ICT Quiz - Databases (Answers)

Which of the following types of information could you store in a database?

[ ]	Information about different products, including descriptions and prices
[ ]	Information about all of the pupils in a school, including name, date of birth and address
[ ]	Information about different countries, including population, climate and language
[x]	All of the above

Data could be any kind of information you want to keep a record of

In a database about planets, all of the information about Mars would be held on what?

[ ]	A field
[ ]	A report
[x]	A record
[ ]	A graph

A record holds all of the information about one person, place or object. On a planet database, all of the information about Mars would be held on one record, while all of the information about Venus would be held on another record

Each record on a database has several different what?

[x]	Different fields
[ ]	Different yards
[ ]	Different graphs
[ ]	Different coordinates

A field contains only one piece of information. A record on a planet database might have several fields: size, distance from the sun, time taken to orbit, number of moons, etc

What is a database search called?

[ ]	A quest
[x]	A query
[ ]	An inquest
[ ]	An answer

A database "query" is a "question" that you ask the database

Imagine an animal database in which each record has these fields: number of legs, habitat, lifespan, diet. Which of the following pieces of information could NOT be found out from the database?

[x]	Whether the animal is a reptile
[ ]	Whether the animal inhabits grassland
[ ]	Whether the animal eats mice
[ ]	Whether the animal has four legs

The database would need an additional field for class (i.e. reptile, mammal, bird, amphibian, fish, etc.) before it could tell you the answer

Which database might you use to help you find your next library book?

[ ]	An encyclopedia
[ ]	A journal
[ ]	A magazine
[x]	A catalogue

A catalogue is a complete list of items, for example all of the books owned by a library

Which fields would you expect to find in a database of library books?

[ ]	Author, title, whether your best friend liked the book
[ ]	Author, title, colour of cover, book condition, how long it will take to read
[x]	Author, title, genre, number of pages, location
[ ]	Author and title only

Besides including information on author, title, genre and number of pages, one of the most important pieces of information is location - this helps you find the book you choose! The database would also be able to tell you if the book was currently available or out on loan

If you had a database for the children in your class and you wanted to organise the list of children by date of birth, you would instruct the database to do what?

[x]	Sort
[ ]	Randomise
[ ]	Alphabetise
[ ]	Save

A database can be sorted alphabetically or numerically by ascending or descending order