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
How can one distinguish among different kinds of parameters? Input parameters are used to pass data to subroutines. Output parameters are used to pass data from subrout

Question 1 Define OLTP? Explain the Differences between OLTP and Data Warehouse Question 2 What is Architecture? Explain various components involved in it Question

Using Relational Algebra which query finds customers, who have a balance of over 1000 ? Using Relational Algebra Π Customer_name( σ balance >1000(Deposit)) is query to find cu

Define outer union operation of the relational algebra. Compute the outer union for the relations R and S given below. Outer Join - If there are any values in one tabl

Use Delegation to Share Implementation The delegation " Delegation comprises of catching an operation on one object and sending it to other object which is part, or related to


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

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

Differance between internal and external schema? Internal and external schema: Internal Schema • Describes the physical storage structure • Uses a physical data model External

Define Aggregate functions and what aggregate functions supported by the MySQL To calculate a summary value from a set of individual values and uses one of the functions known