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 SALES_REP and TERRITORY
a. If a DBMS enforces a DELETE RESTRICT option on the referential integrity constraint between SALES_REP and TERRITORY, show the records in tables SALES_REP and TERRITORY after a user tries to delete the fourth record (N, North) from TERRITORY.
b. If a DBMS enforces a DELETE RESTRICT option on the referential integrity constraint between SALES_REP and TERRITORY, show the records in tables SALES _REP and TERRITORY after a user tries to delete the second record (W, West) from TERRITORY.
c. If a DBMS enforces a DELETE RESTRICT option on the referential integrity constraint between SALES_REP and TERRITORY, show the records in tables SALES_REP and TERRITORY after a user tries to delete the first record (1, Joe, E) from SALES_REP.
d. If a DBMS enforces a DELETE CASCADE option on the referential integrity constraint between SALES_REP and TERRITORY, show the records in tables SALES_REP and TERRITORY after a user tries to delete the fourth record (N, North) from TERRITORY.
e. If a DBMS enforces a DELETE CASCADE option on the referential integrity constraint between SALES_REP and TERRITORY, show the records in tables SALES _REP and TERRITORY after a user tries to delete the second record (W, West) from TERRITORY.
f. If a DBMS enforces a DELETE CASCADE option on the referential integrity constraint between SALES_REP and TERRITORY, show the records in tables SALES_REP and TERRITORY after a user tries to delete the first record (1, Joe, E) from SALES_REP.
g. If a DBMS enforces a DELETE SET-TO-NULL option on the referential integrity constraint between SALES_REP and TERRITORY, show the records in tables SALES_REP and TERRITORY after a user tries to delete the fourth record (N, North) from TERRITORY.
h. If a DBMS enforces a DELETE SET-TO-NULL option on the referential integrity constraint between SALES_REP and TERRITORY, show the records in tables SALES_REP and TERRITORY after a user tries to delete the second record (W, West) from TERRITORY.
i. If a DBMS enforces a DELETE SET-TO-NULL option on the referential integrity constraint between SALES_REP and TERRITORY, show the records in tables SALES_REP and TERRITORY after a user tries to delete the first record (1, Joe, E) from SALES_REP.
j. If a DBMS enforces a DELETE SET-TO-DEFAULT option on the referential integrity constraint between SALES_REP and TERRITORY, show the records in tables SALES_REP and TERRITORY after a user tries to delete the fourth record (N, North) from TERRITORY. Assume that the default value for the DeptID column in the SALES_REP relation is €˜E€™.
k. If a DBMS enforces a DELETE SET-TO-DEFAULT option on the referential integrity constraint between SALES_REP and TERRITORY, show the records in tables SALES_REP and TERRITORY after a user tries to delete the second record (W, West) from TERRITORY. Assume that the default value for the DeptID column in the SALES_REP relation is €˜E€™.
l. If a DBMS enforces a DELETE SET-TO- DEFAULT option on the referential integrity constraint between SALES_REP and TERRITORY, show the records in tables SALES_REP and TERRITORY after a user tries to delete the first record (1, Joe, E) from SALES_REP. Assume that the default value for the DeptID column in the SALES_REP relation is €˜E€™.

Transcribed Image Text:

TERRITORY SALES REP SRID TerName East West South North Central TerID TerID SRName Joe Sue Meg Bob Joe Pat Lee Joe