Question: When creating matching primary keys and foreign keys, which one is NOT a referential integrity rule? When deleting the primary key, forbid it from being

When creating matching primary keys and foreign keys, which one is NOT a referential integrity rule?
When deleting the primary key, forbid it from being deleted when there are foreign keys that depend on it
When deleting the primary key, the foreign keys that dependent on it are automatically set to null.
When deleting the primary key, the foreign keys that dependent on it are also automatically deleted.
When deleting the primary key, the foreign keys that dependent on it automatically take the value of another primary key.

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:

Create the tables as per the Database design given to you in the content. If you think about a different design, that's fine too, just justify why you think that will work better. Create the primary...

Q:

When an event participated in a stock-flow relationship, which of the following is true? The other participant in the relationship must be a focal event. The other participant in the relationship...

Q:

MIS 3 3 0 6 Database Management Systems Module 3 Exercise 4 0 points Required for Grading: I am ( type your full name ) and I complete this assignment following the UHD academic integrity policy. ( 5...

Q:

The resource that is most likely to be found in multiple business processes in all types of organizations is: Employee Cash Cash disbursement Inventory sale Which pair is most likely to be linked...

Q:

The resource that is most likely to be found in multiple business processes in all types of organizations is: Employee Cash Cash disbursement Inventory sale Which pair is most likely to be linked...

Q:

multiple choice 13. Which of the following statement is correct regarding internal control ? A) A well-designed and operated internal control environment should detect collusion perpetrated by two...

Q:

PART 1: Answer the following questions: 1. What is a Primary Key, and why is it important? 2. What is the referential integrity rule? 3. What is the entity integrity rule? 4. The referential...

Q:

Stuck on a problem I need to identify and Apply the normalization process to the following 2 relations , Show the following steps for each relation: here is a preview of what it should look like...

Q:

CIS 4600 Business Database Applications Homework 2 [Due date: 2/14/20191 Using Microsoft SQL Server Databasel Spring 2019 This assignment involves creation of database tables, fields, primary keys...

Q:

MULTIPLE CHOICE QUESTIONS 1. Nulls, if used improperly, can create problems because they can represent ____. a. a default value b. a known, but missing, attribute value c. zero d. an unsortable value...

Q:

1. What factors should be considered when developing inventory systems for the 10,000 items carried by Dano's? What are the key differences between items that would affect how their inventory is...

Q:

Hambelton Ltd. issued $3,300,000 of 5% bonds payable on 1 September 20X9 to yield 4%. Interest on the bonds is paid semi-annually and is payable each 28 February and 31 August. The bonds were dated 1...

Q:

In the application of the equity method, what is the proper investor s accounting for dividends received from the investee? What is the proper investor s accounting for earnings / losses reported by...

Q:

you can skip it. plz dont copy paste otherwise i report Table 2.1 below: - wills are given in Table 2.1. Experimental values of the Quantum defect n-nou for Penetrating orbita in Lithium and Sodium...

Q:

In Visual Studio 2017 with an open OLAP Cube, what is the connection to an advanced OLAP viewer?

Q:

What is the main benefit of the multidimensional framework of OLAP Cubes?

Q:

Provide an example of how the sort level Unspecified can be excluded from the Gender Dimension in a Pivot Table worksheet genderwaggap01.