Question: 2 8 . What referential integrity option we should add to our foreign key constraint to allow deletion of matching rows from child tables when

28 .

What referential integrity option we should add to our foreign key constraint to allow deletion of matching rows from child tables when a row is deleted from parent table?

* 30

points ON UPDATE SET DEFAULT ON DELETE CASCADE ON DELETE SET NULL ON UPDATE CASCADE

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

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

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

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

need help on how to complete this project in a step by step/ click by click way. sani New Perspectives Access 2016 Modules 1-4: SAM Capstone Project la Sandra Coates Skating Club CREATING TABLES,...

CIS395 Database Systems I - Foreign Keys Lab - In order to get complete credit for this lab, you must provide all the source code used on a separate .sql or .txt file. - Create a word document and...

Assignment 1: Setting up Databases (15%) This assignment relates to the following Cowrse Learning Requirements: CLR 1 - Plan, Prepare, Install, Configure, and Use a market-leading Database Management...

CHAPTER 3 1. Which of the following is a correct statement? a. You can restore the data deleted with the DROP COLUMN clause, but not the data deleted with the SET UNUSED clause. b. You cant create...

-- ************************************************************* -- This script creates the database -- for Labs 4-7 based on OM (Order Management) database -- **REVISED by PRP to remove some orders...

A. Lab # : BSBA BIS245A-2 B. Lab 2 of 7 : Skills Development in Visio; Creation of MS Access Database C. Lab Overview Scenario / Summary COs: 1. Given a business situation in which managers require...

needed a bit of help on the ones I got wrong or why I got them wrong I wasnt given an ER diagram to do this. this was all the information I received. Question 1 0/2 points In order to be used as a...

TABLES FOR THE ASSIGNMENT CREATE TABLE CustomerService.Reps ( RepID int IDENTITY(1,1), CONSTRAINT PK_RepID PRIMARY KEY CLUSTERED (RepID), BusinessEntityID int not null, CONSTRAINT FK_BusinessEntityID...

The basic contracting rules for all Federal Government agencies are set forth in: A) Defense Acquisition Regulation B) Federal Acquisition Regulation C) Armed Services Procurement Regulation D)...

After finding the sample mean and sample range for each of the 25 days, find the values of x and R. Also find the values of LCL and UCL for an R chart, then find the values of LCL and UCL for an x...

Financing activities have no impact on the income statement, but rather are reflected in changes in long - term debt and short - term debt on the balance sheet. Group of answer choices True False

CT Corp Comprehensive Question Canadian Tire Corporation, Limited (Canadian Tire) is a family of companies that includes a retail segment and a financial services division, among others. The retail...

Ethics.Teamwork. A manager of a department store tries to follow a company policy that prohibits off-the-clock work requirements of employees;however, store managers have to keep payroll costs below...

Search the Internet to learn about the International Association of Virtual Assistants. Answer the following questions: a. How large is the groups membership? b. What are the dues? c. What are the...

Locate an example of a contract. Describe the four essential elements applicable to this contract. a. Offer and acceptance b. Competency of parties c. Legality of subject matter d. Consideration