Using a suitable example, explain how a relational DBMS would enforce a foreign key constraint under the following circumstances: (a) adding a new row to the referencing table (b) removing an existing...

Using a suitable example, explain how a relational DBMS would enforce a foreign key constraint under the following circumstances:

(a) adding a new row to the referencing table

(b) removing an existing row from the referenced table

(c) changing the value of a matching candidate key. Use the terminology introduced in this chapter and include a discussion of referential actions in your answer.