Menu

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

For this assignment you will indicating changes if any when the proposed DELETE or UPDATE operations are performed. SALES_REP3. If a DBMS enforces a DELETE CASCADE option on the referential integrity constraint between SALES_REP and TERRITORY, show t

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 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
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… . . .

OR


Leave a Reply

Your email address will not be published. Required fields are marked *