E6.2 Consider the two tables shown in Figure 6.36:
E6.2a 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).
E6.2b 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).
E6.2c 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).
E6.2d 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).
E6.2e 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).
E6.2f 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).
E6.2g 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).
E6.2h 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).
E6.2i 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).
E6.2j 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 TerID column in the SALES_REP relation is “E.”
E6.2k 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 TerID column in the SALES_REP relation is “E.”
E6.2l 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 TerID column in the SALES_ REP relation is “E.”