[solved]-Assignment Indicating Changes Proposed Delete Update Operations Performed Salesrep Territo Q39006178

This is for intro to database. Thanks!

For this assignment you will indicating changes if any when the proposed DELETE or UPDATE operations are performed. SALES_REP TERRITORY SRID | SRName TerlD TerlD TerName 1 E E w S Joe Sue Meg Bob Joe Pat Lee Joe Zool East West South North Central N 6 N 7 N 8 E 1. If a DBMS enforces a DELETE 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 delete the second record (W, West) from TERRITORY: 2. If a DBMS enforces a DELETE 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 delete the first record (1, Joe, E) from SALES REP. 3. If a DBMS enforces a DELETE 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 delete the fourth record (N,North) from TERRITORY: 4. If a DBMS enforces a DELETE 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 delete the first record (E, East) from SALES REP. Show transcribed image text For this assignment you will indicating changes if any when the proposed DELETE or UPDATE operations are performed. SALES_REP TERRITORY SRID | SRName TerlD TerlD TerName 1 E E w S Joe Sue Meg Bob Joe Pat Lee Joe Zool East West South North Central N 6 N 7 N 8 E
1. If a DBMS enforces a DELETE 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 delete the second record (W, West) from TERRITORY: 2. If a DBMS enforces a DELETE 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 delete the first record (1, Joe, E) from SALES REP. 3. If a DBMS enforces a DELETE 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 delete the fourth record (N,North) from TERRITORY: 4. If a DBMS enforces a DELETE 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 delete the first record (E, East) from SALES REP.

Expert Answer

---

Answer to For this assignment you will indicating changes if any when the proposed DELETE or UPDATE operations are performed. SALE… . . .