Untitled

A table is the fundamental structure for organizing the data in a database. It's a very simple idea It's a very easy thing to undertstand, and you almost certainly use tables several times a day either directly.

Everything from the nutritional label of a food, to

Spreadsheets applications, such as Micrsoft Excel, or Google Sheets is a common way - and are often themselves used as a database solution (albeit with their own pros and cons in usage).

A table is simply an organization of data where there are rows and columns of data.

A row typically refers to some single thing. This could be a financial transaction like a deposit or purchase, a measurement of something like a weight.

The columns define the attributes or properties that can be given to the things in the table.

If you have a list of TODOs you might have

Name	Notes	Due

You very likely use some sort of Todo app on your phone.

It is also very likely that it uses the same database software that this book utilized - SQLite

History of Tables