Question: 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

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 SALES_REP and TERRITORY
a. 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) from TERRITORY.
b. 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) from TERRITORY.
c. 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 first record (1, Joe, E) from SALES_REP.
d. 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.
e. 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 second record (W, West) from TERRITORY.
f. 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.
g. 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 fourth record (N, North) from TERRITORY.
h. 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 second record (W, West) from TERRITORY.
i. 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 (1, Joe, E) from SALES_REP.
j. If a DBMS enforces a DELETE 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 delete the fourth record (N, North) from TERRITORY. Assume that the default value for the DeptID column in the SALES_REP relation is €˜E€™.
k. If a DBMS enforces a DELETE 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 delete the second record (W, West) from TERRITORY. Assume that the default value for the DeptID column in the SALES_REP relation is €˜E€™.
l. If a DBMS enforces a DELETE 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 delete the first record (1, Joe, E) from SALES_REP. 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.42 Rating (184 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock

a The record would not be deleted because there are records 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 ... 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 (1149).docx

120 KBs Word File

Students Have Also Explored These Related Databases Questions!

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

Consider the two tables T1 and T2 shown in Figure 6.15. Show the results of the following operations:

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

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

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.

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

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

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

A constant-pressure R-134a vapor separation unit separates the liquid and vapor portions of a saturated mixture into two separate outlet streams. Determine the flow power needed to pass 6 L/s of...

ABC Bank pays 1% interest per month. If you invest $5000 today and keep in the bank for a year what is the compound (total interest)?

Explain why bigness and monopoly power are not necessarily the same.

A competitive firm has marginal cost function MC(x) = 3 + x/20,000. The total cost function for this firm is TC(x) = F1 + F2 + 3x + x2/40,000, where F1 and F2 are fixed costs: The firm can avoid...

Consider a grid file in which we wish to avoid overflow buckets for performance reasons. In cases where an overflow bucket would be needed, we instead reorganize the grid file. Present an algorithm...

Consider the account relation as shown below. a. Construct a bitmap index on the attributes branch-name and balance, dividing balance values into 4 ranges: below 250, 250 to below 500, 500 to below...

Show how to compute existence bitmaps from other bitmaps. Make sure that your technique works even in the presence of null values, by using a bitmap for the value null.

Sample run 1 Enter text: The two kids played and played, and finally got tired, and fall asleep a : 8 b : 0 c : 0 d : 7 e : 6 f : 2 g : 1 h : 1 i : 3 j : 0 k : 1 1 , : m m , 0 n : 4 @: 2 p : 3 q : 0...

Question 1(1 point) Given the nature of both tools, the solution selection matrix is a more complex tool to select solutions compared to the impact/effort matrix. Question 1 options: TrueFalse...

how do i answer The Journal of Travel conducted research by taking two large groups (viewed as populations) to determine whether there are differences in the characteristics of the two groups of...