| Everyday term | Formal term | Meaning |
|---|---|---|
| Table | Relation | Data arranged in rows and columns |
| Row / record | Tuple | One entry, such as one student |
| Column / field | Attribute | One property, such as name |
| Number of columns | Degree | Count of attributes |
| Number of rows | Cardinality | Count of tuples |
| Set of allowed values | Domain | Values an attribute may take |
Degree = columns. Cardinality = rows.
- Relation = table, tuple = row, attribute = column.
- Degree counts columns; cardinality counts rows.
- A DBMS reduces redundancy and inconsistency.