What is a cascading update, Database Management System

Assignment Help:

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.

Related Discussions:- What is a cascading update

IT Assignmnet, i need help for assignment ..

i need help for assignment ..

Create student db and perform delete operation, Create Student DB and perfo...

Create Student DB and perform delete operation? STUDENT (name, student#, class, major) COURSE (course name, course#, credit hours, department) SECTION (section identifier, co

Data warehouse, #queDefine a job scheduling strategy that will meet busines...

#queDefine a job scheduling strategy that will meet business requirement of reporting availability by 6am CST for the following cubes? Show the job scheduling dependencies in a pic

Special workarea for interface, While using extract datasets it is required...

While using extract datasets it is required to have a special workarea for interface False. It is not required to have a special workarea for interface

Write a short note on participation role, write a short note on participati...

write a short note on participation role? Participation role: roles are indicating in E-R diagram by labelling the lines that connect diamonds to rectangles.

Physical database design issues, Physical Database Design Issues The da...

Physical Database Design Issues The database design includes the process of logical design with the use of E-R diagram, normalisation, etc., followed by the physical design.

Marketing interface, as a customer service employee explain five measures y...

as a customer service employee explain five measures you would recommend to make even a displeased students patronize the school canteen

The internal or physical level in dbms, The Internal or Physical Level ...

The Internal or Physical Level The collection of files permanently stored on secondary storage devices is called as the physical database. The internal or physical level is t

Explain a data dictionary, What is a data dictionary? Data Dictionary ...

What is a data dictionary? Data Dictionary is a main source of data in a data management system. Its major function is to carry the creation and management of data definition

Strict 2pl-two phase locking (2pl), Strict 2PL :Though, this basic 2PL suff...

Strict 2PL :Though, this basic 2PL suffers from the trouble that it can result into loss of isolation / atomic property of transaction as theoretically speaking once a lock is rele

Write Your Message!

Name

Email id

Message

Verfication Code

User Account

All Pages