Terminology
Relational database theory uses a set of mathematical terms, which are roughly equivalent to SQL database terminology. The table below summarizes some of the most important relational database terms and their SQL database equivalents.
| Relational term | SQL equivalent |
|---|---|
| relation, base relvar | table |
| derived relvar | view, query result, result set |
| tuple | row |
| attribute (name) | column name |
| relation scheme, set of attributes | set of column names |
| attribute value | column (data) |
Read more about this topic: Relational Database