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

Ask an Expert

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

Write your message here..

Related Questions

Cascading rollback, explain cascading rollback explain cascading rollback

Secondary indexes, Secondary Indexes Let consider the student database ... 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-data redundancy, Deletion Anomalies: Loss of important ... 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, Whst is logical schema ? Logical schema is the ... Whst is logical schema ? Logical schema is the entire database.

Explain traditional programming languages, How persistent programming langu... 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 from database, Find out the names of al... 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';

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

Limitations of dbms, what are the limitations of dbms? what are the limitations of dbms?

Describe log based recovery, Describe log based recovery The most usabl... 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

Database design and documentation, A use case diagram giving a pictorial ov... 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