E$6\mathrm{.}1$ Consider the two tables shown in Figure $6\mathrm{.}36.$ The TerID column in the SALES$\_$REP relation is a foreign key referring to the primary key column TerID in the TERRITORY relation.

E$6\mathrm{.}1$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.

E$6\mathrm{.}1$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.

E$6\mathrm{.}1$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 TerID column in the SALES$\_$REP relation is $$E$.$

E$6\mathrm{.}1$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 TerID column in the SALES$\_$REP relation is $$E$.$

E$6\mathrm{.}1$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 TerID column in the SALES$\_$REP relation is $$E$.$