Question

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

Answer 1

Answer:

All records of relation B related with that record of relation A will be deleted

Explanation:

After deletion of a record from relation A will delete all of the records from relation B where their foreign key is the primary key of the record being deleted from relation A.