Title - Relational databases. Tags - databases sql rdbms
Data organised in tables with relationships between the tables.
A Relational Database Management System (RDBMS) is software that controls relational databases.
Structured Query Language (SQL) can be used to manage and update an RDBMS.
A table is a collection of data organised into rows and columns.
Tables are sometimes referred to as relations.
Columns represent data values of a particular type, e.g. ID, Name, Age.
Rows represent a single record in the table, e.g. 1 in for the ID column, Justin Bieber for the name column, and 22 for the age column.
Data in a relational database is of a certain data type. Most common are:
INTEGER - position or negative whole number
TEXT - a text string
DATE - date formatted as YYYY-MM-DD
REAL - a decimal value