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. It was first introduced in 1970 following the work of E.F.Codd.
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: Database Constraints