Question: Consider relations A and B . Relation A represents the entity on the one side of a one - to - many relationship; Relation B
Consider relations A and B Relation A represents the entity on the one side of a onetomany relationship; Relation B represents the entity on the many side of the onetomany relationship. 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
Group of answer choices
no records will be deleted
the record in relation A and all of 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 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
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
