Question: If the restrict option is chosen when enforcing the Referential Integrity rule, what happens when a user tries to delete a primary key value that

If the "restrict" option is chosen when enforcing the Referential Integrity rule, what happens when a user tries to delete a primary key value that is NOT referenced in the foreign key column?

DBMS will delete this primary key value and replace it with a null value.

The entire row associated with this primary key will be deleted.

The DBMS will set all values in the foreign key to null values.

If the "restrict" option is chosen when enforcing the Referential Integrity

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!

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

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

Database Administration CHAPTER OBJECTIVES I Understand the need for and importance of database I ttno'illI the meaning of ACID transaction administralin - Learn the tour 1992 ANSI standard isolation...

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

Observe the HOMETOWN REALESTATE database: SELLER Sellers S111 S222 S333 S444 S555 C666 .C777 SellerName Paul Carly Ana Charlotte Aidan Eric Christina Realtorld R1 R1 R2 R2 R3 R1 R1 REALTOR RealtorID...

Exercises E6.1 Consider the two tables shown in Figure 6.37. The TerlD column in the SALES REP relation is a foreign key re- ferring to the primary key column TerlD in the TERRI- E6.1c If a DBMS...

Primary and Secondary Keys E6.2.a, E6.2.c, E6.2.g Only point out which rows are affected (if any) do not have to show the entire table(s) when process is finished Conformity 198 Consistency 198...

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

rcises E6.1c If a DBMS enforces a DELETE RESTRICT Toption Consider the two tables shown in Figure 6.37. The TerlD column in the SALES REP relation is a foreign key re- ferring to the primary key...

E6.1 Consider the two tables shown in Figure 6.36. The TerID column in the SALES_REP relation is a foreign key referring to the primary key column TerID in the TERRITORY relation. (PLEASE DO NOT COPY...

Brewers at Singh Brewery work full-time or part-time. Full-time employees work either 8 AM to 4 PM, 11 AM to 7 PM, or 1 PM to 9 PM. The shifts of part-time employees are 12 PM to 4 PM or 3 PM to 8...

Use the theorem in Sec. 71, involving a single residue, to evaluate the integral of f (z) around the positively oriented circle |z| = 3 when (a) (b) (c) f(z) (3z 2)2 23(1 3z) (1 z(12z4) f(z)13 1 +23

who assumes the economic risk for defined benefit pension plans? 1 - Actuaries 2 - Trustees 3 - Employees Employers

Periodic Inventory Using FIFO, LIFO, and Weighted Average Cost Methods The units of an item available for sale during the year were as follows: Jan. 1 Inventory 11 units at $27 $297 Aug. 13 Purchase...

Strong understanding of technology and systems, and business process improvement

3. Describe how Great-Wests invoice approvals process changed after the mobile application was deployed.

13-5 What are new approaches for system building in the digital firm era?