A database is a structured collection of related data about one or more subjects. E.g. a school database to store student records or a library database to keep track of books loaned.
| Within a database there are tables. A table holds data about a particular item. E.g. a student table or the loans table. |
![]() |
| Within each table there are records. A record is a collection of information that stores all of the data about one person or one thing. For instance a record in student table would contain all of the data about one student i.e. their name, address, home phone number, d.o.b. medical history. Each student would have a record. |
![]() |
Each item within a record is called a field. Fields are the individual items that make up a record within your database. In the example of a student table, a field would be first name or surname or form. |
![]() |
Next Page |




