Topics / Databases / Database Table

Database Table

A database table (sometimes called a file) is a collection of records about the same entity (topic).

Some databases contain just a single database table (called a flatfile database) whilst others may have many tables (called a relational database).

Example:

The database for a library may contain the following tables:

  • Members
  • Books
  • Loans

The database for a school may contain the following tables:

  • Students
  • Teachers
  • Classes
  • Parents

 

Topics / Databases / Database Table