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

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 5. 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 third record (S, South) from TERRITORY (Assume that the default value for the Terld in the TERRITORY is ‘U’, ‘Unknown”). 6. If a DBMS enforces a 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 LO (NO, North) 7. If a DBMS enforces a UDPATE 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 UPDATE the record (N, North) from TERRITORY tO (NE, North East): 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
5. 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 third record (S, South) from TERRITORY (Assume that the default value for the Terld in the TERRITORY is ‘U’, ‘Unknown”). 6. If a DBMS enforces a 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 LO (NO, North) 7. If a DBMS enforces a UDPATE 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 UPDATE the record (N, North) from TERRITORY tO (NE, North East):

Expert Answer

---

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