Skip to main content

relational model

relational model A data model that views information in a database as a collection of distinctly named tables. Each table has a specified set of named columns, each column name (also called an attribute) being distinct within a particular table, but not necessarily between tables. The entries within a particular column of a table must be atomic (that is, single data items) and all of the same type. The logical records held in a relational database are viewed as rows in these tables. Each logical record is thus constrained to contain only a set of elementary data items each of a prespecified type. The model is, in consequence, also known as the flat file model.

The model, first proposed by Codd in 1969 and used exclusively in the context of database management systems, takes its name from an analogy that can be drawn between a table as described and the mathematical concept of a relation. In this analogy table corresponds to relation, row (in a table) to tuple (of a relation), and the column names (of the table) to the domain ordering (in the relation). Using this analogy Codd developed various sets of operations on which languages for the manipulation of such tables might be based and from which the now widely used data sublanguage SQL is derived.

In spite of its name, which can be a source of confusion, the model makes no provision for maintaining relationships between rows in different tables and the only constraint on the rows within a particular table is that no two rows are identical. Each row, from the viewpoint of the model, is thus an independent entity. It can only be related to other rows by correspondences between contained data items, which is a matter for the user.

See also normal forms, foreign key, ERA model.

Cite this article
Pick a style below, and copy the text for your bibliography.

  • MLA
  • Chicago
  • APA

"relational model." A Dictionary of Computing. . Encyclopedia.com. 15 Oct. 2018 <http://www.encyclopedia.com>.

"relational model." A Dictionary of Computing. . Encyclopedia.com. (October 15, 2018). http://www.encyclopedia.com/computing/dictionaries-thesauruses-pictures-and-press-releases/relational-model

"relational model." A Dictionary of Computing. . Retrieved October 15, 2018 from Encyclopedia.com: http://www.encyclopedia.com/computing/dictionaries-thesauruses-pictures-and-press-releases/relational-model

Learn more about citation styles

Citation styles

Encyclopedia.com gives you the ability to cite reference entries and articles according to common styles from the Modern Language Association (MLA), The Chicago Manual of Style, and the American Psychological Association (APA).

Within the “Cite this article” tool, pick a style to see how all available information looks when formatted according to that style. Then, copy and paste the text into your bibliography or works cited list.

Because each style has its own formatting nuances that evolve over time and not all information is available for every reference entry or article, Encyclopedia.com cannot guarantee each citation it generates. Therefore, it’s best to use Encyclopedia.com citations as a starting point before checking the style against your school or publication’s requirements and the most-recent information available at these sites:

Modern Language Association

http://www.mla.org/style

The Chicago Manual of Style

http://www.chicagomanualofstyle.org/tools_citationguide.html

American Psychological Association

http://apastyle.apa.org/

Notes:
  • Most online reference entries and articles do not have page numbers. Therefore, that information is unavailable for most Encyclopedia.com content. However, the date of retrieval is often important. Refer to each style’s convention regarding the best way to format page numbers and retrieval dates.
  • In addition to the MLA, Chicago, and APA styles, your school, university, publication, or institution may have its own requirements for citations. Therefore, be sure to refer to those guidelines when editing your bibliography or works cited list.