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 30 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).
Join a community of subject matter experts. Register for FREE to view solutions, replies, and use search function. Request answer by replying!