Relational model: Difference between revisions

Revision as of 20:26, 27 December 2023

Revision as of 07:41, 28 December 2023

Line 19:

A ''relation'' consists of a ''heading'' and a ''body''. The heading defines a [[Set (mathematics)|set]] of ''attributes'', each with a ''name'' and ''data type'' (sometimes called a ''___domain''). The number of attributes in this set is the relation's ''degree'' or ''[[arity]]''. The ''body'' is a set of ''tuples''. A ''tuple'' is a collection of ''n'' ''values'', where ''n'' is the relation's degree, and each value in the tuple corresponds to a unique attribute.{{refn|group=nb|Despite its name, a ''tuple'' in the relational model is not a mathematical [[tuple]]. In mathematics, the elements of a tuple are ordered. In the relational model, attributes are unordered, so the corresponding elements in a tuple are also unordered.}} The number of tuples in this set is the relation's ''[[cardinality]]''.<ref name="professionals"/>{{rp|17-22}}

Relations are represented by ''relational [[Variable (computer science)|variables]]'' or ''relvars'', which can be reassigned.<ref name="professionals"/>{{rp|22-24}}. A ''[[database]]'' is a collection of relvars.<ref name="professionals"/>{{rp|112-113}}.

In this model, databases follow the ''Information Principle'': At any given time, all [[Information theory|information]] in the database is represented solely by values within tuples, corresponding to attributes, in relations identified by relvars.<ref name="professionals"/>{{rp|111}}