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

What is dml (data manipulation language)?, This language that enable user m... This language that enable user manipulate to or access data as organized by appropriate data model. Low level or Procedural DML : DML needs a user to specify what data ar

What are the benefits of document scanning, What are the benefits of docume... What are the benefits of document scanning? Document scanning, in addition to being cost-efficient, also enhances productivity. This service enhances security as you set the pa

Explain the aggregation implies concurrency, Explain the Aggregation implie... Explain the Aggregation implies concurrency Concurrency actually is: This in objects can be identified by the way they change state. Present objects can change state independen

Query, Use a Set operator to create a list of academics who have written or... Use a Set operator to create a list of academics who have written or co-written less than 5 papers and also have greater than 3 interests. List their academic number in the output.

What is management system, What is Management System? A management syst... What is Management System? A management system is a set of rules and process which help us to create organize and manipulate the database. It also helps us to add, change delet

What is a transaction? , What is a transaction ? The Transaction is a un... What is a transaction ? The Transaction is a unit of data processing. For instance, many of the transactions at a bank may be withdrawal or deposit of money; transfer of money f

Create a e-r diagram, Information about films holds information about movie... Information about films holds information about movies, stars and studios. Movies have a title, year of production, length and the film type. Stars have a name and address. Studi

Outer join, Outer Join: The use of Outer Join is that it still joins those... Outer Join: The use of Outer Join is that it still joins those tuples that do not have matching values in common columns are also contained in the result table. Outer join places

Develop a java application, 1 - Serial RS232 comm port comunication 2 - ... 1 - Serial RS232 comm port comunication 2 - NanoHTTPD serving a few processed pages 3 - System tray application to indicate status and access configuration forms 4 - SQLit

BMIS 351, Ask question #MinimRead Dennis et al. Chapter 6: Minicase 2. Work... Ask question #MinimRead Dennis et al. Chapter 6: Minicase 2. Work through it and answer the questions. See the attached example. SequenceDiagram.png Based on the structural mod