The following table with purchase orders is created: What happens upon deletion of a supplier? a. All

Question:

The following table with purchase orders is created:

CREATE TABLE PURCHASE_ORDER (PONR CHAR(7) NOT NULL PRIMARY KEY, PODATE DATE, SUPNR CHAR(4) NOT NULL, FOREIGN

What happens upon deletion of a supplier?

a. All purchase order records tied to that supplier are also deleted.

b. The SUPNR of this supplier is replaced by a NULL value in PURCHASE_ORDER.

c. The SUPNR of this supplier is deleted in PURCHASE_ORDER.

d. The SUPNR of this supplier is only deleted in SUPPLIER.

Fantastic news! We've Found the answer you've been seeking!

Step by Step Answer:

Related Book For book-img-for-question

Principles Of Database Management The Practical Guide To Storing Managing And Analyzing Big And Small Data

ISBN: 9781107186125

1st Edition

Authors: Wilfried Lemahieu, Seppe Vanden Broucke, Bart Baesens

See More Books

Question Posted: Dec 18, 2023 01:32 AM

See More Questions

Planning is one of the most important management functions in any business. A front office managers first step in planning should involve determine the departments goals. Planning also includes...
Managing Scope Changes Case Study Scope changes on a project can occur regardless of how well the project is planned or executed. Scope changes can be the result of something that was omitted during...
A light cargo train of mass 3000kg accelerates from rest at station A and reaches a velocity of 113km/h in 25 seconds. It then travels at constant velocity for 30seconds before the driver applies the...
Is the PS assessment a valid predictor of performance as a store manager? Would you recommend the PS be used in the future to select sales people for promotion to store manager?
What accounting and reporting methods are used by investor-venturers in accounting for their joint venture investments?
Ankel Footwear employees three salespeople, and pays time-and-a-half for overtime. Weekly paychecks are distributed on the Tuesday following the last day of the week (Saturday). Ankel withholds...
Zapata, a Texas company, entered into a contract for Unterweser, a German company, to tow an oil-drilling rig from Louisiana to Italy. The contract stated, Any dispute arising must be treated before...
Francisco Inc. acquired 100 percent of the voting shares of Beltran Company on January 1, 2014. In exchange, Francisco paid $450,000 in cash and issued 104,000 shares of its own $1 par value common...
a) The trial balance of Nyaguthie enterprises prepared as at 30th April, 2016 failed to balance. The difference was posted to a suspense account. On investigation, the following errors were revealed....
Write an SQL query that retrieves each supplier who can deliver product 0468 within one or two days, accompanied by the price of the product and the delivery period.
Consider the following ER model for a course administration. Which statement is not correct? a. When mapping the ER relationship type teaches between Session and Teacher to the relational model, a...
You decide to start a business selling covers for smart phones in a mall kiosk. To buy inventory, you need to borrow some funds. Why are you more likely to take out a bank loan than to issue bonds?
2. Perform k-means algorithm on the dataset given below. The two red dots are the initial random centroids and there are ten data points. In the first sub-graph, the decision boundary is drawn...
What was the tittle of the first ever photographic exhibition?
Mary enters into a 5-year lease for a factory owned by Norma. She says she intends to open a pottery business. The lease contains clauses that restrict assignment or subletting without the landlord's...
Does Samsung have a cost advantage (YES/NO), a differentiation advantage (YES/NO), or both a cost and differentiation advantage (YES/NO) over its rivals?
Read the Fact Pattern and use the IRAC outline to Answer the question. After a gallery opening of a photography exhibit in New York, local authorities challenged the work of pictures of nude people...
Robin is single and purchases a new home for $80,000 in the current year. She pays $8,000 down and borrows the remaining $72,000 by securing a mortgage on the home. Robin pays $1,750 in closing...
H.J. Heinzs annual dividends were as follows: 1990 ..............$0.540 1991.............. 0.620 1992 .............. 0.700 1993.............. 0.780 1994 .............. 0.860 1995 .............. 0.940...
It is desired to send a sequence of computer screen images over an optical fiber. The screen is 2560 1600 pixels, each pixel being 24 bits. There are 60 screen images per second. How much bandwidth...
Calculate the end-to-end transit time for a packet for both GEO (altitude: 35,800 km), MEO (altitude: 18,000 km) and LEO (altitude: 750 km) satellites.
What is the latency of a call originating at the North Pole to reach the South Pole if the call is routed via Iridium satellites? Assume that the switching time at the satellites is 10 microseconds...
Exercise 4-2: Lets say that we are using a finite-difference scheme to compute some derivative of a function f(t): 1 (-3f(t)+4f(t+ At) f(t + 2At)) 2At Which derivative are we computing (i.e., f'(t),...
Without graphing, find the two points of intersection of the graphs of the f(x) = -4x+1 and g(x) = x + 7x+25. Enter the points of intersection as ordered pairs separated by a semi-colon such as...
Given the function f(a) = 5a+ 14, solve for f(a) = 0. 5a+14, Give an exact answer; do not round.

The following table with purchase orders is created: What happens upon deletion of a supplier? a. All

Question:

CREATE TABLE PURCHASE_ORDER (PONR CHAR(7) NOT NULL PRIMARY KEY, PODATE DATE, SUPNR CHAR(4) NOT NULL, FOREIGN KEY (SUPNR) REFERENCES SUPPLIER (SUPNR) CASCADE); ON DELETE CASCADE ON UPDATE

Step by Step Answer:

The correct answer is aAll purchase order records tied to that supplier are also deleted This is bec...View the full answer

Principles Of Database Management The Practical Guide To Storing Managing And Analyzing Big And Small Data

Students also viewed these Computer science questions