Answer Happy

Posted: **Thu Jul 14, 2022 2:27 pm**

: 2 Question 2 Consider The Two Tables Shown In Figure 1 The Terid Column In The Sales Rep Relation Is A Foreign Key Ref 1 (1.56 MiB) Viewed 31 times

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) Figure 1 Relations SALEO_REP and TERRITORY
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).