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
Explain the function of input controls. Identify four types of input control and explain the function of each. Provide an example of a data integrity error that could occur i

Explain the Recoverable Schedule A recoverable schedule is one in which for each pair of transactions Ti and Tj such that Tj reads a data item formerly written by Ti, the comm

Product adder required for Ecommerce website Project Description: Want a product adder for 500 products I have a magento website and need products pulled from site A to my si

what should be included in this???

why are older data models are being replaced by new data models

Components of database manager The above functions are reached by the database manager. The major elements of a database manager are: Authorisation control: This mod

what is relationship inheritance and attribute inheritance

What is DML Query Langauge? Data Manipulation Language (DML) - A data manipulation language is a language in which enables users to access or manipulate data as organized throu

What is the difference between a HAVING CLAUSE and a WHERE CLAUSE? HAVING CLAUSE - HAVING CLAUSE is used only with SELECT statement. - It is normally used in a GROUP BY

Benefits of using heuristics