Question: Exercises E6.1 Consider the two tables shown in Figure 6.37. The TerlD column in the SALES REP relation is a foreign key re- ferring to

Exercises E6.1 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- E6.1c If a DBMS enforces a DELETE RESTRICT option on the referential integrity constraint SALES REP and TERRITORY, show the in tables SALES REP and TERRITORY after TORY relation. E6.1a user tries to delete the first record (1, Jor, E) from 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, Nortk) 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.1e 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. SALES REP TERRITORY SRID SRName TerlD TerlD TerName E East W West S South N |North C Central 2 Sue 5 Joe 6 Pat 7 Lee 8 Joe FIGURE 6.37 The relations Sales Rep and Territory E6.1f 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 first record (1, Joe, E) from SALES REP 7 DELETE SET-TO-NULL

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

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

Consider the two tables shown in Figure 6.37. The TerID column in the SALES_REP relation is a foreign key referring to the primary key column TerID in the TERRITORY relation. Figure 6.37 Relations...

E 6 . 1 Consider the two tables shown in Figure 6 . 3 6 . The TerID column in the SALES _ REP relation is a foreign key referring to the primary key column TerID in the TERRITORY relation. E 6 . 1 h...

E6.1 Consider the two tables shown in Figure 6.36. The TerID column in the SALES_REP relation is a foreign key referring to the primary key column TerID in the TERRITORY relation. E6.1b If a DBMS...

E6.1 Consider the two tables shown in Figure 6.36. The TerID column in the SALES_REP relation is a foreign key referring to the primary key column TerID in the TERRITORY relation. (PLEASE DO NOT COPY...

MIS 430 Data Warehousing es (1s points. Consider the two tables shown in the following figure. The TerlD column in the SALES REP relation is a foreign key referring to the primary key column TerlD in...

Primary and Secondary Keys E6.2.a, E6.2.c, E6.2.g Only point out which rows are affected (if any) do not have to show the entire table(s) when process is finished Conformity 198 Consistency 198...

I need with these problems/exercises listed below (chapters attached). You must use the chapters to fill out the guidance report which is attached. Using the data for March/April Column. Chapter...

Utilizing the text book,pages 264-278 In paragraph (1) Identify one country that has a current and excessive Trade Surplus. Identify the products that are responsible for the Trade Surplus, you may...

Wagner Co., a U.S. firm, pursued a 6-year project in Russia. It purchased a manufacturing plant from the Russian government 6 years ago for 500 million rubles. Since the ruble was worth $.16 at the...

The machine part is held in place using the double-end clamp. The bolt at B has square threads with a mean radius r and a lead r1, and the coefficient of static friction with the nut is s. If a...

The life expectancy of a dollar bill is estimated to be just over six years. After six years, it will need to be replaced. Which characteristic of money does this statement illustrate?

The Cable Service Division reported the following activity for the month of March: Basic Enhanced Premium Sales : 5 0 , 0 0 0 5 0 0 , 0 0 0 3 0 0 , 0 0 0 Price per unit: $ 3 2 $ 6 0 $ 9 0 Unit costs:...

4. How did Anthems new data analytics capabilities change the Human Resources function at the company?

12-4 How do different decision-making constituencies in an organization use business intelligence, and what is the role of information systems in helping people working in a group make decisions more...

11-18 How do enterprise content management systems help organizations manage structured and semistructured knowledge? What are two examples of each type of knowledge handled by these systems?