UKUK USUSIndiaIndia
Progress you can see
Parents Students Tutors Teachers QuizMaster
Join Us
UKUK USUSIndiaIndia
Join Us
KS1 (Age 5-7)KS2 (Age 7-11)11 Plus (Age 7-11)KS3 (Age 11-14)GCSE (Age 14-17)PSHEA.I.ESLSpanishSpecialistGames
Lucy
Ask the AI Tutor
Need help with Databases? Ask our AI Tutor!
Lucy AI Tutor - Lucy
Connecting with Tutor...
Please wait while we establish connection
Lucy
Hi! I'm Lucy, your AI tutor. How can I help you with Databases today?
now
0/50 words
  1. Home
  2. KS2
  3. ICT
  4. Databases
Databases
A database could be made of all the planets showing their size, their distance from the Sun and much, much more!

Databases

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

1 .
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
Data could be any kind of information you want to keep a record of
2 .
In a database about planets, all of the information about Mars would be held on what?
A field
A report
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
3 .
Each record on a database has several different what?
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
4 .
What is a database search called?
A quest
A query
An inquest
An answer
A database "query" is a "question" that you ask the database
5 .
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
The database would need an additional field for class (i.e. reptile, mammal, bird, amphibian, fish, etc.) before it could tell you the answer
6 .
Which database might you use to help you find your next library book?
An encyclopedia
A journal
A magazine
A catalogue
A catalogue is a complete list of items, for example all of the books owned by a library
7 .
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
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
8 .
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 database can be sorted alphabetically or numerically by ascending or descending order
9 .
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
A list of planets could be sorted alphabetically OR by distance from the sun, but not both at the same time (this applies to the time taken to orbit, as well)
10 .
What is another name for the information held in a database?
IQ
Data
Snippets
Fun facts
A database holds ... data!
You can find more about this topic by visiting BBC Bitesize - Working with data

Author:  Sheri Smith (PhD English Literature, English Teacher & Quiz Writer)
ICT Play this quiz again

Here to Help

Contact Us
FAQs
Your Account

Resources

Parents Knowledge Bank Blog Links and Resources Quiz List and Sitemap Colour Filters Safe AI Survey Results

About

Our Team Testimonials Parent Reviews Terms and Conditions Privacy Polity

© Copyright 2016-2026 - Education Quizzes
Work Innovate Ltd - Design | Development | Marketing

We use cookies to enhance your experience on our website.

To comply with the e-Privacy directive, we need your consent - I agree - No thanks - Learn more