Question: I need help with this assignment pleaseee!!!! SALES REP TERRITORY SRIDSRName TerID TerID TerName West South North Central 3 5 6 Pat 8 For each

I need help with this assignment pleaseee!!!!

SALES REP TERRITORY SRIDSRName TerID TerID TerName West South North Central 3 5 6 Pat 8 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 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 2. 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: 3. 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 (N. North) from TERRITORY

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!

MANAGEMENT INFORMATION SYSTEMS IS SUBJECT WAS UNSURE WHERE TO PUT IT. 1. If a DBMS enforces a DELETE CASECADE OPTION on the referential integrity constraint between SALES_REP and TERRITORY show the...

POINTS: 100 TOTAL, EACH QUESTION IS WORTH 5 POINTS Instructions for submitting your assignment 1. Save this file and remember the location. Please recall the general assignment instructions about...

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

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

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 option on the referential...

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

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

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

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

Consider the following two tables for answering the following Questions . The TerID column in the SALES_REP relation is a foreign key referring to the primary key column TerID in the TERRITORY...

On June 1, 2014, Portugal Inc. reported a cash balance of $12,000. During June, Portugal made deposits of $3,000 and made disbursements totaling $14,000. What is the cash balance at the end of June?...

Carbon from a cypress beam obtained from the tomb of Sneferu, a king of ancient Egypt, gave 8.1 disintegrations of 14C per minute per gram of carbon. How old is the cypress beam? Carbon from living...

Matteo quit smoking. Paul did not. How long will it take for Mateo's risk of dying from lung cancer to drop to half the risk that Paul faces? Multiple Choice 6 months 1 year 5 years 1 0 years

Seved Help 14 Wisconsin Snowmobile Corp. is considering a switch to level production Cost efficiencies would occur under level production, and aftertax costs would decline by $31,500, but inventory...

10. What learning conditions are necessary for short- and long-term retention of training content to occur?

13. What is a design document? What is included in a design document? How is it useful for training?

7. Your boss says, Why do I need to tell you what type of learning capability Im interested in? I just want a training program to teach employees how to give good customer service! Explain to the...