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 kind of advantages to copying records from one table to another? -) When an algorithm that modifies a table is used after that it's safer to work with the copy -) When

Q.   Why would you choose a database system instead of simply storing data in operating system file? Define  at a base concept in details. Sol. Advantages of Database over Fil

Examples:- Hierarchical Model: It tells data as and relationships by hierarchy of data values. Figure illustrates an example of hierarchical model. Now a day's these models are

Improved Reliability: In a centralised DBMS, a server failure stops the operations of the DBMS. Though, a failure at single site of a DDBMS, or a failure of a communication link cr

Problem : (b) A deductive database system is essentially the outcome of applying mathematics logic to database management, where logic is used for both data representation and

Determine Which is not a consequence of concurrent operations? Ans: Update anomaly.

Consider entity type Employee with attributes empNumber (this is unique), empName, and the year when he/she was hired. An employee can either be a technical employee, a marketing e

How to create values of structured type? Constructor functions are used to make values of structured types. A function with the similar name as a structured type is a construct

Describe domain constraints. Domain constraints contain entity integrity and referential integrity. The domain is a set of values that might be assigned to an attribute. The en

System level permissions : With the use of data dictionary you can view them.       Let us take the table name as user_sys_privs (used in oracle).       DESCRIBE USER_SYS_PRI