Modify - referential integrity, Database Management System

Update or Modify operation alters the existing values. If these operations alter the value that is the foreign key also, the only check need is the similar as that of the Insert operation.

What should happen to an try to update a candidate key that is the objective of a foreign key reference? For instance, an attempt to update the PROJID "LG" for which there exists at least one matching ASSIGNMENT tuple? In common there are the similar possibilities as for DELETE operation:

RESTRICT: The update operation is "restricted" to the case where there are not matching assignment tuples. (it is rejected otherwise).

CASCADE - The update operation "cascades" to update the foreign key in those matching assignment tuples also.

Posted Date: 3/6/2013 6:39:41 AM | Location : United States







Related Discussions:- Modify - referential integrity, Assignment Help, Ask Question on Modify - referential integrity, Get Answer, Expert's Help, Modify - referential integrity Discussions

Write discussion on Modify - referential integrity
Your posts are moderated
Related Questions
What are the object-oriented approaches Software systems which are designed with structured design methodology never support some of desired quality attributes for example reus

What does authentication refer? Authentication refers to the task of verifying the uniqueness of a person.

Using SQL create a view RS for the relations R and S. The view consists of the columns A and D renamed as X and Y in that order. Insert a tuple into it. Show the contents of t

Importance Of File Organisation In Database To execute a database efficiently, there are various design tradeoffs needed. One of the most vital ones is the file Organisation. F

A database is a set of data. But, is the data kept in a database trustworthy? To answer that query we must first answer the question. What is integrity? Integrity simply means t

The database will enable college administrators the ability to track students initial major. This will help college officials decide how best to prepare students for their goals an


What are the two types of indices? The two types of indices are:- A)     Dense index B)      Sparse index

Relational Algebra is a set of basic operations used to influence the data in relational model. These operations allow the user to specify basic retrieval request. The result of re

Explain the Attribute inheritance Ans: Throughout the rendering of the objects in a view, attribute sets of objects higher in the view hierarchy are inherited via objects below