atomic value
each value in the domain is indivisible as far as the relational model is concerned
A domain is the original sets of atomic values used to model data.
attribute
principle storage unit in a database
The columns in a table is a field and is also referred to as an attribute.
column
see attribute
The columns in a table is a field and is also referred to as an attribute.
degree
number of attributes in a table
The degree is the number of attributes in a table.
domain
the original sets of atomic values used to model data; a set of acceptable values that a column is allowed to contain
A domain is the original sets of atomic values used to model data.
field
see attribute
The columns in a table is a field and is also referred to as an attribute.
file
see relation
A relation, also known as a table or file, is a subset of the Cartesian product of a list of domains characterized by a name.
record
contains fields that are related; see tuple
You can also think of it this way: an attribute is used to define the record and a record contains a set of attributes.
relation
a subset of the Cartesian product of a list of domains characterized by a name; the technical term for table or file
The relational data model describes the world as “a collection of inter-related relations (or tables).”
row
see tuple
And within a table, each row represents a group of related data values.
structured query language (SQL)
the standard database access language
Developers use structured query language (SQL) to create, query and update the tables of a relational database.
table
see relation
The relational data model describes the world as “a collection of inter-related relations (or tables).”
tuple
a technical term for row or record
As noted earlier, a tuple is another term used for record.
These terms were extracted from Database Design – 2nd Edition by Adrienne Watt, eCampusOntario (originally published by BCcampus) which is licensed under a Creative Commons Attribution 4.0 International License. Chapter text adapted from Relational Design Theory by Nguyen Kim Anh, licensed under CC BY 3.0.