Question: If the foreign key constraint for the EventPlanLine.LineNo column includes ON DELETE CASCADE, deleting a row of the EventPlan table Group of answer choices will

If the foreign key constraint for the EventPlanLine.LineNo column includes ON DELETE CASCADE, deleting a row of the EventPlan table
Group of answer choices
will delete related rows in the EventPlanLine table.
will not be allowed if there are related rows in the EventPlan table.
will set the primary key of related EventPlanLine rows to the null value.
will set the primary key of related EventPlanLine rows to a default value.

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!

Q:

Exercise 2-2 The balance sheets of Petrello Company and Sanchez Company as of January 1, 2014, are presented below. On that date, after an extended period of negotiation, the two companies agreed to...

Q:

352800 pohce S15.00 R1$2000 305 If the foreign key constraint for the EventPlanLine.LineNo column includes ON DELETE CASCADE, deleting a row of the EventPlan table o will delete related rows in the...

Q:

First visit HYPERLINK "http://www.tdan.com/view-articles/5174/" http://www.tdan.com/view-articles/5174/ and learn what data related business rules are. Business rules are precisely written and...

Q:

Please answer each query and display the output Query 1: Create a new table, FACULTY5, and populate it with faculties in department ID 5, using an existing table. Use faculty ID, name, and salary...

Q:

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

Q:

could someone please help me these access assignment Accounting Information Systems Access Assignment S&S Revenue Database Introduction to Microsoft Access: Microsoft Access is representative of...

Q:

16. The external model yields some advantages such as ______________ a. use of the database subsets to make application program development much simpler. b. use of the database subsets to make...

Q:

This part is to get you familiar with expressing queries in Relational Algebra and to further familiarize you with the tables used to implement the telephone switching database from assignment #2....

Q:

Part 1) Queries with Relational Algebra This part is to get you familiar with expressing queries in Relational Algebra and to further familiarize you with the tables used to implement the telephone...

Q:

haa23684_PlugInT6CD.qxd 9/6/06 5:38 PM Page 2 CONFIRMING PAGES P L U G - I N T6 Basic Skills and Tools Using Access LEARNING OUTCOMES 1. Describe the primary functions using Microsoft Access. 2....

Q:

1. Your company uses 2 tables to store product information named LocalProducs and InternationalProducts. You also use a table named Orders that stores open order information. You must retrieve the ID...

Q:

Each year Briggs & Stratton (producer of gasoline engines) estimates its own company- wide weighted average cost of capital. In 2001, it based its calculation on the following assumptions (info taken...

Q:

What actions can an organization initiate to better control employee theft and fraud?

Q:

13. Using the Find a REIT section of the Invest in REITs site, http://www.investinreits.com/ findaREIT/findareit.cfm, select two publicly traded real estate investment trusts in different property...

Q:

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

Q:

(Appendices) PURCHASES, PURCHASE RETURNS, AND PAYMENT FOR PURCHASES. Jordan Footwear sells athletic shoes. During April Jordan made the following purchases on credit with terms 3/15, n/40: LO4 Assume...

Q:

(Appendices) SALES AND SALES RETURNS WITH DISCOUNTS. Fuente Office Supply sells all merchandise on credit with terms 2/10, n/30. Fuente engaged in the following transactions: a) May 1: Fuente sold 50...

Q:

(Appendices) Choose five food, beauty, or household products you find in your home. Visit a local store and compare three different sizes of the product and compute unit prices. Compile the...