Structured Query Language [SQL]
FOREIGN KEY
A field (or collection of fields) in one table that uniquely identifies a row of another table.
Tuple
A row in a database.
PRIMARY KEY
A unique identifier for each record in a database table.
INSERT
This SQL statement is used to add new data into a database.
CREATE
This SQL statement is used to create a table in a database.
DROP
This SQL statement is used to delete a table from a database.
DELETE
This SQL statement is used to delete rows in a table.
WHERE
This SQL statement is used to return data which meets specified requirements.
SELECT
This SQL statement is used to select data from a database.
ORDER BY
This SQL statement is used to sort the result-set by one or more columns and is ascending by default.
UPDATE
This SQL statement is used to update data records in a database.
CASCADE
Whatever happens to the master table, will effect the child table.