IRMA-International.org: Creator of Knowledge
Information Resources Management Association
Advancing the Concepts & Practices of Information Resources Management in Modern Organizations

Inclusion Dependencies

Inclusion Dependencies
View Sample PDF
Author(s): Laura C. Rivero (Universidad Nacional del Centro de la Provincia de Buenos Aires, Argentina and Universidad Nacional de La Plata, Buenos Aires, Argentina)
Copyright: 2005
Pages: 6
Source title: Encyclopedia of Information Science and Technology, First Edition
Source Author(s)/Editor(s): Mehdi Khosrow-Pour, D.B.A. (Information Resources Management Association, USA)
DOI: 10.4018/978-1-59140-553-5.ch251

Purchase

View Inclusion Dependencies on the publisher's website for pricing and purchasing information.

Abstract

Inclusion dependencies support an essential semantics of the standard relational data model. An inclusion dependency is defined as the existence of attributes (the left term) in a table R whose values must be a subset of the values of the corresponding attributes (the right term) in another table S (Abiteboul, Hull & Vianu, 1995; Codd, 1990; Connolly, Begg & Strachan, 1999; Date, 2000). When the right term conforms a unique column or a primary key (K) for the table S, the inclusion dependency is key-based (also named referential integrity restriction, rir). In this case, the left term is a foreign key (FK) in R and the restriction is stated as R[FK] <

Related Content

Adeyinka Tella, Oluwakemi Titilola Olaniyi, Aderinola Ololade Dunmade. © 2021. 24 pages.
Md. Maidul Islam. © 2021. 17 pages.
Peterson Dewah. © 2021. 23 pages.
Lungile Precious Luthuli, Thobekile K. Buthelezi. © 2021. 14 pages.
Delight Promise Udochukwu, Chidimma Oraekwe. © 2021. 13 pages.
Julie Moloi. © 2021. 18 pages.
Mandisa Msomi, Lungile Preciouse Luthuli, Trywell Kalusopa. © 2021. 17 pages.
Body Bottom