Consider the two tables shown in Figure 6.36. The TerID column in the SALES_REP relation is a foreign key referring to the primary key column TerID in the TERRITORY relation.
E6.1a 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.
E6.1b 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.
E6.1c 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.
E6.1d 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.
E6.1e 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.
E6.1f 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.
E6.1g 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.
E6.1h 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.
E6.1i 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.
E6.1j 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 TerID column in the SALES_REP relation is “E.”
E6.1k 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 TerID column in the SALES_REP relation is “E.”
E6.1l 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 TerID column in the SALES_REP relation is “E.”