Let’s focus on what relational databases are and how they are organised.

relational database is a database that organises information into one or more tables.

table is a collection of data organised into rows and columns. Tables are sometimes referred to as relations.

column is a set of data values of a particular type.

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 
/* ]]> */