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
Smart Alex Catering Sevice (SACS) is a company offering top class catering staff  for prestigious events.  The company employs approximately 200 hourly paid contact staff - chefs,

Determine the advantage of object-orientation Finally, object-orientation has advantage of continuity throughout analysis, persistent representation and design implementation.

how to implement hyrise in C plus plus

Entity types that do not have any key attribute, and therefore cannot be identified independently, are known as weak entity types. A weak entity can be recognized uniquely only by

The Maximum no of key fields that can be used in a header is?? 50

Write short notes on relational constraints? Relational Constraints are: 1. NOT NULL 2. Unique 3. Primary key 4. Foreign key 5. Table check

Attribute Preservation This is a easy and obvious necessity that includes preserving all the attributes that were there in the relation that is being decomposed.

What is the function of SQL Server Agent Windows service? - It's a Windows service that handles tasks scheduled within SQL Server environment. These tasks are also known as job

If R1 and R2 are two union compatible relations or functions, then the result of R3 = R1 ∩R2 is the relation that contains all tuples that are in both the relations In other words,

What are wait-for-graphs?Give the algorithm to construct a wait-for-graph from a given schedule of transactions? How can deadlocks be detected from wait-for-graphs?   Ans:  The