Encyclopedia of Database Systems

Living Edition
| Editors: Ling Liu, M. Tamer Özsu

Relational Model

Living reference work entry
DOI: https://doi.org/10.1007/978-1-4899-7993-3_306-2

Synonyms

Definition

The Relational Model describes data as named relations of labeled values. For example, customer ID’s can relate with customer names and addresses in the relational model as Customer: {<(CustomerID, 11111), (Name, Pat), (Address, 12 Maple)>, <(CustomerID, 22222), (Name, Tracy), (Address, 44 Elm)>}. In this example, there is a name for the relation - Customer; label-value pairs - e.g., (CustomerID, 11111), which provide the labeled values; and tuples - e.g., <(CustomerID, 11111), (Name, Pat), (Address, 12 Maple)>, which are the tuples of the named relation.

Usually, the relations of the relational model are viewed as tables. Fig. 1 shows an example of several relations viewed as tables. Together, they constitute a relational database. The first table in Fig. 1 is the table view of the relation described in the previous paragraph.
This is a preview of subscription content, log in to check access

Recommended Reading

  1. 1.
    Atzeni P, De Antonellis V. Relational database theory. Redwood City: The Benjamin/Cummings Publishing Company, Inc.; 1993.MATHGoogle Scholar
  2. 2.
    Codd EF. A relational model for large shared data banks. Commun ACM. 1970;13(6):377–487.CrossRefMATHGoogle Scholar
  3. 3.
    Elmasri R, Navathe SB. Fundamentals of Database Systems. 5th ed. Boston: Addison-Wesley; 2007.MATHGoogle Scholar
  4. 4.
    Maier D. The theory of relational databases. Rockville: Computer Science Press, Inc.; 1983.MATHGoogle Scholar
  5. 5.
    Silberschatz A, Korth HF, Sudarshan S. Database system concepts. 5th ed. New York: McGraw-Hill; 2006.MATHGoogle Scholar

Copyright information

© Springer Science+Business Media LLC 2016

Authors and Affiliations

  1. 1.Brigham Young UniversityProvoUSA