Databases contain tables. Tables are two-dimensional data structures containing rows and columns. A row corresponds to a single record in a database and records are divided into columns. Think of database tables like a specialized spreadsheet.
The many multiple tables in a MariaDB database have columns, which can relate in one way or another. For example, the
id column in an employee table may relate to the
employee_id column in an address table. These relationships (also called foreign keys
) are why we call MariaDB a relational database.
A database without tables of data is nothing more than a name. Until we create some tables and start adding data to those tables, our database is empty and useless.