Referential integrity constraint - relational constraints, Database Management System

It defines that the tuple in one relation that refers to another relation must refer to an existing tuple in that relation. This constraint is states on two relations (not essentially distinct). It uses a concept of foreign key and has been dealt with in more factors in the next unit.



1599_referential integrity constraint.png

In the example given above, the value of C^ in every R tuple is matching with the value of C# in some S tuple. If a tuple has values (A6, B2, and C4) is added then it is invalid as referenced relation S doesn't contain C4. Therefore, it will be a violation of referential integrity constraint.

Posted Date: 3/6/2013 5:33:35 AM | Location : United States

Related Discussions:- Referential integrity constraint - relational constraints, Assignment Help, Ask Question on Referential integrity constraint - relational constraints, Get Answer, Expert's Help, Referential integrity constraint - relational constraints Discussions

Write discussion on Referential integrity constraint - relational constraints
Your posts are moderated
Related Questions
Define decision tree classifiers? As the name suggests decision tree classifiers use a tree: Every leaf node has an associated class, and every internal node has a predicate as

#A multinational tour operator agency has gained new business growth in the North American market through the use of social media. Its operation has expanded by 50% within six mont

why data in an RDMS need to be normalised

Selective replication: This is a combination of generating small fragments of relation and replicating them rather than a entire relation. The data should be fragmented on require

What are the types of storage devices? Primary storage Secondary storage Tertiary storage Volatile storage Nonvolatile storage

Illustrate the term- Abstracting Out Common Behaviour Inheritance is not every time recognised during analysis phase of development, thus it is necessary to re-evaluate object

Niles Video Inc. wants to create a website for online sales of movies (DVD and videotapes). People will be allowed to register as customers on the website and to update their store

What are the disadvantages of file-processing system?  Ans: The Disadvantages of File-Processing System a. Data redundancy and inconsistency - Data redundancy means not nece

The Proliferation of Object-Oriented Methods The first few years of the 1990s saw blossoming of around fifty various object oriented methods. This proliferation is a sign of g

(a) Design a query plan for the following distributed query: An application at site B wants to compute a join of STUDENT ? Id=StudId TRANSCRIPT where STUDENT (Id,Major) is at site