Question: The delete rule between relations A and B is restrict. If an attempt is made to delete a record in relation A and its primary

The delete rule between relations A and B is restrict.

If an attempt is made to delete a record in relation A and its primary key value appears as a foreign key value in one or more records of relation B

____

the record in relation A will be the only record deleted and no other changes will occur

only the records in relation B with foreign key values that match the primary key value of the record in relation A will be deleted

the record in relation A will be the only record deleted and the foreign key values in relation B that match the primary key value of the record in relation A will be updated to null

no records will be deleted

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 Programming Questions!

Explain many to many relationships and how to deal with them in design. Describe referential integrity. Describe in detail the three delete rules. Consider relations A and B. Relation A represents...

True-False Questions 1. Normalizing accounting data refers primarily to eliminating errors and outliers, thus creating ?normal data.? 2. An important reason for normalizing data is to eliminate data...

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

In mysql Assignment Scenario The Chinook company has realized they could make better, more efficient use of their dutabase if they convert more of its commenlyeused functionality over to using stored...

Consider relations A and B . Relation A represents the entity on the one side of a one - to - many relationship; Relation B represents the entity on the many side of the one - to - many relationship....

1. Consider the following ANIMAL and ENCLOSURE relations from the Central Zoo relational database. The left-hand column of relative record numbers is there to facilitate answering some of the...

What would happen if: The delete rule between the SHIP and CRUISE relations is restrict and an attempt is made to delete the record for ship number 0 1 2 in the SHIP relation? The delete rule between...

2. In the General Hardware Corp. database of Figure 6.1, what would happen if: a. The delete rule between the CUSTOMER and CUSTOMER EMPLOYEE relations is restrict and an attempt is made to delete the...

2) Assume the Administrator and School relations contain the following data: (note primary keys are underlined while foreign keys are bold and italic) Administrator School SchoolNumber Name Address...

Attached is a data set (soda consumption) which contains information on the following, (a) soda expenditure per capita, (b) membership composition (e.g. presence of elementary students, HS students,...

Interview someone who is old enough to remember events (no one who was not at least 20 in the year 2000) from 1975-2000 and ask them what they think is the most important event or series of events of...

Anastasia and Christian are executive managers at Magical Artifacts Inc. They realize that within the last several quarters, they have been heavily focused on the online customer satisfaction rating...

QUESTION 3 Use polar coordinates to find the volume of the given solid. Show your work separately and submit using the assignment link. Under the paraboloid z = x 2 + y 2and above the disk x 2 + y 2...