Question: Consider the two tables shown in Figure 6.37: Figure 6.37 Relations SALES_REP and TERRITORY a. If a DBMS enforces an UPDATE RESTRICT option on the

Consider the two tables shown in Figure 6.37:

Figure 6.37 Relations SALES_REP and TERRITORY
a. If a DBMS enforces an 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 to (NO, North).
b. If a DBMS enforces an 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 second record (W, West) in TERRITORY to (WE, West).
c. If a DBMS enforces an 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 first record (1, Joe, E) in SALES_REP to (1, Joe, C).
d. If a DBMS enforces an UPDATE 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 change the fourth record (N, North) in TERRITORY to (NO, North).
e. If a DBMS enforces an UPDATE 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 change the second record (W, West) in TERRITORY to (WE, West).
f. If a DBMS enforces an UPDATE 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 change the first record (1, Joe, E) in SALES_REP to (1, Joe, C).
g. If a DBMS enforces an UPDATE 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 change the fourth record (N, North) in TERRITORY to (NO, North).
h. If a DBMS enforces an UPDATE 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 change the second record (W, West) in TERRITORY to (WE, West).
i. If a DBMS enforces an UPDATE 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 change the first record (1, Joe, E) in SALES_REP to (1, Joe, C).
j. If a DBMS enforces an UPDATE 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 change the fourth record (N, North) in TERRITORY to (NO, North). Assume that the default value for the DeptID column in the SALES_REP relation is €˜E€™.
k. If a DBMS enforces an UPDATE 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 change the second record (W, West) in TERRITORY to (WE, West). Assume that the default value for the DeptID column in the SALES_REP relation is €˜E€™.
l. If a DBMS enforces an UPDATE 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 change the first record (1, Joe, E) in SALES_REP to (1, Joe, C). Assume that the default value for the DeptID column in the SALES_REP relation is €˜E€™.

TERRITORY SALES REP SRID TerName East West South North Central TerID TerID SRName Joe Sue Meg Bob Joe Pat Lee Joe

Step by Step Solution

★★★★★

3.44 Rating (173 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock

a The record would not be updated because there are values in the SALESREP table that have N as a foreign key SALESREP SRID SRName TerID 1 Joe E 2 Sue E 3 Meg C 4 Bob S 5 Joe N 6 Pat N 7 Lee N 8 Joe E ... View full answer

Question Has Been Solved by an Expert!

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

Step: 2 Unlock

Step: 3 Unlock

Document Format (1 attachment)

623-CS-DB (1150).docx

120 KBs Word File

Students Have Also Explored These Related Databases Questions!

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

Use the database composed of the two tables shown in Figure Q3.18. Identify the primary keys. Figure Q3.18. Table name: DIRECTOR DIR_NUM DIR_LNAME DIR_DOB 100 Broadway 12-Jan-65 18-Nov-53 101...

Use the database composed of the two tables shown in Figure Q3.18. Suppose you wanted quick lookup capability to get a listing of all plays directed by a given director. Which table would be the...

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

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

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

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

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

Subject: Relational Database For each of the following questions, please show both tables including all tuples (rows) present after the described operation. 1. If a DBMS enforces a DELETE RESTRICT...

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

A proposed hotel, Willards, is scheduled to open in one year. The business will be organized as a sole proprietorship. The owner, Monica Willards seeks your advice on pricing. Although she knows she...

It is often argued that private country clubs tend to have low-quality food operations because the members do not join or frequent their clubs for the food but rather for the golf and fellowship. ( A...

Classifying variable and xed manufacturing costs Classify each of the following as a vari - able or xed cost with respect to a unit of production: ( a ) Salaries of production supervisors ( b ) Steel...

Acompetitivefirmhas total cost function TC(x) = 5 million+5x+x2/10,000. Regarding its fixed cost of $5 million, $4 million can be avoided if the firm produces 0, but $1 million is completely...

How does data encryption affect index schemes? In particular, how might it affect schemes that attempt to store data in sorted order?

Why is it not desirable to force users to make an explicit choice of a queryprocessing strategy? Are there cases in which it is desirable for users to be aware of the costs of competing...

Consider the following SQL query for our bank database select T.branch-name from branch T, branch S where T.assets > S.assets and S.branch-city = Brooklyn Write an efficient relational-algebra...

Estimate a multiple linear regression relationship with the U.K. stock returns as the dependent variable, and U.K. Government Bond yield (Interest rate), U.S. Stock Returns, and Japan Stock Returns...

A machine that cost $ 1 2 0 , 0 0 0 3 years ago can be sold now for $ 5 2 , 7 5 0 . Its market value is expected to be $ 4 0 , 0 0 0 and $ 2 0 , 0 0 0 1 year and 2 years from now, respectively. Its...

Answer using JASP Software, etc. Is there a difference in profit in the first quarter compared to the second quarter for investor's portfolios? Each participant's investment portfolio was evaluated...