Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

rcises E6.1c If a DBMS enforces a DELETE RESTRICT Toption Consider the two tables shown in Figure 6.37. The TerlD column in the SALES REP

image text in transcribed
rcises E6.1c If a DBMS enforces a DELETE RESTRICT Toption Consider the two tables shown in Figure 6.37. The TerlD column in the SALES REP relation is a foreign key re- ferring to the primary key column TerlD in the TERRI 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 (I, Joe, E) from SALES REP TORY relation. E6.1a 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 fourth record (N, North) E6.1d 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 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 from TERRITORY E6.1b 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) E6.le from TERRITORY SALES REP SRID SRName TerlDTerlD TerName 1 Joe 2 Sue 3 TERRITORY W West S South N North 4 Bob 5 Joe N C Central Pat

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

1 2 3 Data Base Techniques

Authors: Dick Andersen

1st Edition

0880223464, 978-0880223461

More Books

Students also viewed these Databases questions

Question

A 300N F 30% d 2 m Answered: 1 week ago

Answered: 1 week ago