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

Define query optimization, Define query optimization. Query optimizatio... Define query optimization. Query optimization refers to the process of search the lowest -cost method of evaluating a given query.

NORRMALIZATION, Home based assignment Consider an ORDER table with the foll... Home based assignment Consider an ORDER table with the following attributes: • Order Number (ONo),Customer Number (CNo),Customer Name (CNa),Item Number (INo),Unit Price (UP), Quant

What is primary index, Primary Index In primary index, there is a one-t... Primary Index In primary index, there is a one-to-one relationship among the entries in the index table and the records in the major table. Primary index can be of two types:

Distinguish among a datareader class and a dataset class, Question (a) ... Question (a) Concurrent access to data from a database is a normal part of application program usage. Describe three approaches to concurrency control (b) Distinguish among

Ideal data dictionary, An ideal data dictionary should have everything a DB... An ideal data dictionary should have everything a DBA wants to know about the database. 1 Conceptual, External, and internal database descriptions. 2.    Descriptions of attr

Define two-phase locking protocol, Define two-phase locking protocol. A... Define two-phase locking protocol. Ans: Two-phase locking is significance in the context of ensuring that schedules are serializable. The two-phase locking protocol defines a p

Aims of the design project, The aims of the project are: 1. To enable th... The aims of the project are: 1. To enable the students to undertake the detailed design of a specific plant or process 2. The design projects includes: process selection; und

Define physical and logical data independence, Define physical and logical ... Define physical and logical data independence. How does this architecture help in achieving these? Data independence entails that change in one view must not need a change in t

What is 2nf, What is 2NF? A relation schema R is in 2NF if it is in 1NF... What is 2NF? A relation schema R is in 2NF if it is in 1NF and every non-prime attribute A in R is fully functionally dependent on primary key.

What is sql profiler, What is SQL Profiler? SQL Profiler is a graphical... What is SQL Profiler? SQL Profiler is a graphical tool that permits system administrators to monitor events in an instance of Microsoft SQL Server. You can capture and save dat