Glossary

Alias A temporary name given to a table in the FROM clause
Cross Join A join listing all possible combination of rows without filtering
Database A collection of organized data. Can be stored in a digital format like on a computer
DBMS Database Management System. A software to control and manage digital databases
Field A column in a table
Foreign Key A column in a table that matches a primary key column in another table
Normalization Breaking down a raw database into tables and removing redundancies
Record A row of a table
SQL Structured Query Language. A language used to interact with databases
Table A matrix like display/abstraction of data in row-column format