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
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? 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 Concurrency actually is: This in objects can be identified by the way they change state. Present objects can change state independen

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? 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 ? 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

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: 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

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

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