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.

Example

 

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

What is hash file organization? What are the causes of bucket overflow within a hash file organization? What can be completed to decrease the occurrence of bucket overflow?

Consider the subsequent relations for a database which keeps track of business trips of salespersons in a sales office: SALESPERSON (SSN, Name, start_year, Dept_no) TRIP (SSN, Fr

Describe in brief about the Sequence Diagrams Sequence diagrams are interaction diagrams which emphasize time ordering of messages. In UML, it is shown as a table which shows

Ask question #MinimRead Dennis et al. Chapter 6: Minicase 2. Work through it and answer the questions. See the attached example. SequenceDiagram.png Based on the structural mod

This project requires you to create a database design.  Your design will be documented in a set of Entity-Relationship diagrams.  Draw a set of Entity-Relationship diagrams to mode

What is data independence? Data Independence: Techniques which permit data to be changed without affecting the applications in which procedure it. There are two types of data

What is a data dictionary?  A data dictionary is a data structure which keeps Meta data about the structure of the database i.e.  the schema of the database.

Define Partial Key and Primary Key A partial key, also known as discriminator, is the set of attributes which can uniquely identify weak entities that are related to similar o