Let’s focus on what relational databases are and how they are organised.
A relational database is a database that organises information into one or more tables.
A table is a collection of data organised into rows and columns. Tables are sometimes referred to as relations.
A column is a set of data values of a particular type.
A row is a single record in a table.
All data stored in a relational database is of a certain data type. Some of the most common data types are:
INTEGER, a positive or negative whole number
TEXT, a text string
DATE, the date formatted as YYYY-MM-DD for the year, month, and day
REAL, a decimal value