Preview lessons, content and tests

Computer Science & Programming solved. All in one platform.

1. To trial the platform and take tests, please take a few seconds to SIGN UP and SET UP FREE.

2. Searching for something specific? See our text overview of all tests. Scroll right for levels, and lists.

3. Student and Teacher User Guides |  Schemes of Work |   Real Teacher use Videos |


Join 36000+ teachers and students using TTIO.

Use of Databases

Databases are involved with everything we do online. From social networking to the BBC website, databases are crucial tools used to store large amounts of data in an organised way.

Suggested intro video

Uses of a Database

Microsoft Office Access is a popular database package but there are alternatives such as OpenOffice Base.

Databases are widely used. Schools, the NHS, supermarkets, Facebook, Google and YouTube all make use of databases. Any company or organisation that stores large amounts of data almost certainly stores it in a database.

The services and companies mentioned above use their databases to:

  • -send letters or emails to employees, clients or customers
  • -manage appointments
  • -track the products customers buy
  • -serve adverts based on what a user searches for
  • -suggest related videos, depending on videos a user has already watched
  • -know which friends two individuals have in common

Your school probably keeps track of the most popular dishes on the canteen menu so that it always has enough to serve to students.

Databases vs. paper

Databases can store huge amounts of data without taking up any space in the real world.

It is much quicker to query or search a database than it is to riffle through hundreds or even thousands of paper records.

www.teachyourselfpython.com