Consider the two tables shown in Figure 6.37:

Figure 6.37 Relations SALES_REP and TERRITORY
a. If a DBMS enforces an UPDATE 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 change the fourth record (N, North) in TERRITORY to (NO, North).
b. If a DBMS enforces an UPDATE 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 change the second record (W, West) in TERRITORY to (WE, West).
c. If a DBMS enforces an UPDATE 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 change the first record (1, Joe, E) in SALES_REP to (1, Joe, C).
d. If a DBMS enforces an UPDATE 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 change the fourth record (N, North) in TERRITORY to (NO, North).
e. If a DBMS enforces an UPDATE 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 change the second record (W, West) in TERRITORY to (WE, West).
f. If a DBMS enforces an UPDATE 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 change the first record (1, Joe, E) in SALES_REP to (1, Joe, C).
g. If a DBMS enforces an UPDATE 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 change the fourth record (N, North) in TERRITORY to (NO, North).
h. If a DBMS enforces an UPDATE 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 change the second record (W, West) in TERRITORY to (WE, West).
i. If a DBMS enforces an UPDATE 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 change the first record (1, Joe, E) in SALES_REP to (1, Joe, C).
j. If a DBMS enforces an UPDATE 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 change the fourth record (N, North) in TERRITORY to (NO, North). Assume that the default value for the DeptID column in the SALES_REP relation is €˜E€™.
k. If a DBMS enforces an UPDATE 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 change the second record (W, West) in TERRITORY to (WE, West). Assume that the default value for the DeptID column in the SALES_REP relation is €˜E€™.
l. If a DBMS enforces an UPDATE 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 change the first record (1, Joe, E) in SALES_REP to (1, Joe, C). 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