2. Tables

Databases store data or information in tables, just like the one below:

database table

The table allows you to see all of the records stored in the database.

Tables can store many records, from a few dozen for a small database up to millions for a large company database.

Here is an example to show you some of the tables that might be stored in a school information database:

Table

Type of data stored

Student information table

name, address, contact details

Student attendance table

Days attended, days absent, reasons for absence

Student exams table

Scores for end of year exams

Staff table

name, address, contact details, qualifications, pay scale

 

DEFINITION: A table stores all of the records for a particular category

 

 

Challenge see if you can find out one extra fact on this topic that we haven't already told you

Click on this link: Database Tables