What is a cascading update, Database Management System

What is a cascading update?

Referential integrity constraints needs that foreign key values in one table correspond to primary key values in another. If the value of the primary key is altered -- that is, updated -- the value of the foreign key must directly be changed to match it. Cascading updates will set this alter to be done automatically by the DBMS whenever essential.

 

Posted Date: 7/4/2013 9:03:36 AM | Location : United States







Related Discussions:- What is a cascading update, Assignment Help, Ask Question on What is a cascading update, Get Answer, Expert's Help, What is a cascading update Discussions

Write discussion on What is a cascading update
Your posts are moderated
Related Questions

Secondary Indexes Let consider the student database and its clustering index and primary (only one will be applicable at a time). Now consider the state when the database is to

Deletion Anomalies: Loss of important Information: In some cases, useful information may be lost when a tuple is deleted. For instance, if we delete the tuple corresponding to stu

Whst is logical schema ? Logical schema is the entire database.

How persistent programming languages differ from traditional programming languages? Database languages vary from traditional programming languages in that they directly manipul

Find out the names of all employees who work for first Bank Corporation from database. SELECT EMPLOYEE_NAME FROM WORKS WHERE COMPANYNAME = ‘First Bank Corporation';

explain three types of internet risks to the consummers whent he business system is data dependent. how can we minimise these risks


Describe log based recovery The most usably structure for recording data base modification is the LOG the log is a sequence of log records recording all the update activities i

A use case diagram giving a pictorial overview of user requirements and brief use case descriptions. As the case study contains only an outline of a business scenario, you will als