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

Relation instance or relation state, A relation instance indicates as r is ... A relation instance indicates as r is a collection of tuples for a given relational schema at a exact point of time. A relation state r of the relation schema R (A 1 ,A 2 ,.....

What is meant by the degree of relationship set, What is meant by the degre... What is meant by the degree of relationship set? The degree of relationship type is the number of participating entity types.

Explain instance and schemas, Explain Instance and schemas? Instances ... Explain Instance and schemas? Instances and schemas: Databases changes over time as the information is deleted and inserted. The collection of information stored in database

Discuss the problem of spurious tuples, Discuss the problem of Spurious tup... Discuss the problem of Spurious tuples and how we may prevent it.    Ans:  A spurious tuple is, mainly, a record in a database that gets created while two tables are joined bad

Dependency Diagram, A Structure of a dependency diagram A Structure of a dependency diagram

DB TECHNOLOGIES, WHAT IS DATABASE TECHNOLOGIES WHAT IS DATABASE TECHNOLOGIES

Entity - relation modeling and transformation, Represent the following scen... Represent the following scenarios with E-R diagrams drawn using the ER Assistant software. The diagrams should indicate cardinality and optionality of relationships. Transform each

What is rdbms, What is RDBMS? Relational Data Base Management Systems (... What is RDBMS? Relational Data Base Management Systems (RDBMS) are database management systems that maintain data records and indices in tables. Relationships may be formed and

Lossless-join decomposition, what is Lossless-join decomposition what is Lossless-join decomposition

DBMS, You are managing the following database system: • DBMS: Oracle 11g... You are managing the following database system: • DBMS: Oracle 11g • OS: Sun Solaris • System architecture: Web-based application using ASP.Net • Purpose of Server: HR manage