[Solved]-1 Dbms Enforces Delete Restrict Option Referential Integrity Constraint Salesrep Territory Q37158462
1. If a DBMS enforces a DELETE RESTRICT option on thereferential integrity constraint between SALES_REP and TERRITORY,show the records in tables SALES_REP and TERRITORY after a usertries to delete the fourth record (N, North) fromTERRITORY.
2. If a DBMS enforces a DELETE CASCADE option on thereferential integrity constraint between SALES_REP and TERRITORY,show the records in tables SALES_REP and TERRITORY after a usertries to delete the fourth record (N, North) fromTERRITORY.
3. If a DBMS enforces a DELETE SET-TO-NULLoption on the referential integrity constraint between SALES_REPand TERRITORY, show the records in tables SALES_REP and TERRITORYafter a user tries to delete the fourth record (N, North)from TERRITORY.
4 If a DBMS enforces an UPDATE RESTRICT option on thereferential integrity constraint between SALES_REP and TERRITORY,show the records in tables SALES_REP and TERRITORY after a usertries to change the fourth record (N, North) in TERRITORYto (NO, North).
5. f a DBMS enforces an UPDATE CASCADE option on thereferential integrity constraint between SALES_REP and TERRITORY,show the records in tables SALES_REP and TERRITORY after a usertries to change the fourth record (N, North) in TERRITORYto (NO, North).
6. If a DBMS enforces an UPDATE SET-TO-NULL option onthe referential integrity constraint between SALES_REP andTERRITORY, show the records in tables SALES_REP and TERRITORY aftera user tries to change the fourth record (N, North) inTERRITORY to (NO, North).
SALES REP TERRITORY SRID SRName TerlDTerlD TerName Joe Sue East W West South N North 2 3 4 Meg Bob Joe Pat Lee Joe Central 6 Show transcribed image text SALES REP TERRITORY SRID SRName TerlDTerlD TerName Joe Sue East W West South N North 2 3 4 Meg Bob Joe Pat Lee Joe Central 6
Expert Answer
Answer to 1. If a DBMS enforces a DELETE RESTRICT option on the referential integrity constraint between SALES_REP and TERRITORY, … . . .
OR
