Answer Happy

2. Question 2 Consider the two tables shown in Figure 1. The TerID column in the SALES REP relation is a foreign key referring to the primary key column TerID in the TERRITORY relation. Answer the following with a short explanation of your answer. (7 points each) SALES REP SRID 1 2 3 4 5 6 7 8 SRName Joe Sue Meg Bob Joe Pat Lee Joe TerlD EUSZ2 с N N E TERRITORY TerlD E W S N C TerName East West South North Central Figure 1 Relations SALES_REP and TERRITORY 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'. 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).