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.
"relational model." A Dictionary of Computing. . Encyclopedia.com. (February 21, 2019). https://www.encyclopedia.com/computing/dictionaries-thesauruses-pictures-and-press-releases/relational-model
"relational model." A Dictionary of Computing. . Retrieved February 21, 2019 from Encyclopedia.com: https://www.encyclopedia.com/computing/dictionaries-thesauruses-pictures-and-press-releases/relational-model
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
The Chicago Manual of Style
American Psychological Association
- 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.