Question: Explain how referential integrity is established in databases that are SQL:1999 compliant. Explain how the on update restrict, on update cascade, and on update set

Explain how referential integrity is established in databases that are SQL:1999 compliant. Explain how the on update restrict, on update cascade, and on update set null clauses differ from one another. What happens if the on delete cascade clause is set?

Step by Step Solution

★★★★★

3.55 Rating (162 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock

Establishing referential integrity using an SQL1999 compliant database and the differences among the ... View full answer

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Document Format (1 attachment)

613-CS-DB (1772).docx

120 KBs Word File

Students Have Also Explored These Related Databases Questions!

The owner of Colonial Adventure Tours would like you to complete the following tasks to help him maintain his database. In the following exercises, you will use the data in the Colonial Adventure...

Consider the two tables shown in Figure 6.37. The TerID column in the SALES_REP relation is a foreign key referring to the primary key column TerID in the TERRITORY relation. Figure 6.37 Relations...

Consider the two tables shown in Figure 6.37: Figure 6.37 Relations SALES_REP and TERRITORY a. If a DBMS enforces an UPDATE RESTRICT option on the referential integrity constraint between SALES_REP...

. Explain how referential integrity is established in databases that are SQL:1999 compliant. Explain how the ON UPDATE RESTRICT, ON UPDATE CASCADE, and ON UPDATE SET NULL clauses differ from one...

Explain how referential integrity is established in databases that are SQL:1999 compliant. Explain how the on update restrict, on update cascade, and on update set null clauses differ from one...

Explain how referential integrity is established in databases that are SQL:1999 compliant. Explain how the ON UPDATE RESTRICT, ON UPDATE CASCADE, and ON UPDATE SET NULL clauses differ from one...

General Knowledge question 1) What is the most common type of DBMS Model ? a) Hierarchical b) Network c) Relational d) Object-Relational e) Object Oriented 2) DBMS systems have commands to look at...

My name is Salam Abdulhussein and I need this to be done as soon as possible. Please follow the steps one by one and make sure everything is correct Global Bike, Inc. ERP for Sales / Collection USING...

What are two ways to report a company's net cash flow from operating activities? Briefly describe the advantages and disadvantages of each method.

Paradise Pools, Inc. (PPI), also known as Paradise Pools and Spas, was incorporated in 1981.In 1994, PPI entered into a contract with Bromanco, Inc., to build a pool in Vicksburg, Mississippi, as...

Which of the following is true regarding the accounting for defined contribution plans? Group of answer choices The employer records pension expense based on an amount provided by the actuary. The...

Do you think it was the right decision for Carrefour to leave Japan? Could it instead have adopted other strategies that perhaps would have led to a different outcome?

Identify each relationship type and write all of the business rules. Discuss.

What does it mean to say that a database displays both entity integrity and referential integrity?

Why are entity integrity and referential integrity important in a database?

A manufacturer of video games develops a new game over two years. This costs $800,000 per year with one payment made immediately and the other at the end of two years. When the game is released, it...

You have the following data. DI = $1.60,70=$55.00, and .30% (coestant). What is the cost of equity from retainied earnings based dividend growth approaeh? a. 2.91% b. 6.85% c. 6.419 d. 5.95%

Consider a Poisson process for which events occur at a rate of 1.5/hr, letT1be the time in hours to the 1st event, and letT3be the time in hours to the 3rd event. (Note:T3is the total time (from time...