2. Tables
Databases store data or information in tables, just like the one below:
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