5. Define the affect the ON DELETE CASCADE statement has as shown below. (5 points) CREATE...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
5. Define the affect the "ON DELETE CASCADE" statement has as shown below. (5 points) CREATE TABLE LINE ( INV_NUMBER LINE NUMBER P CODE INTEGER NOT NULL, NUMERIC(2,0) NOT NULL, VARCHAR(10) NOT NULL, LINE UNITS NUMERIC (9,2) DEFAULT 0.00 NOT NULL, LINE PRICE NUMERIC(9,2) DEFAULT 0.00 NOT NULL, PRIMARY KEY (INV NUMBER,LINE NUMBER), FOREIGN KEY (INV_NUMBER) REFERENCES INVOICE (INV_NUMBER) ON DELETE CASCADE, FOREIGN KEY (P_CODE) REFERENCES PRODUCT(P_CODE), CONSTRAINT LINE_UI1 UNIQUE(INV_NUMBER, P_CODE)); 5. Define the affect the "ON DELETE CASCADE" statement has as shown below. (5 points) CREATE TABLE LINE ( INV_NUMBER LINE NUMBER P CODE INTEGER NOT NULL, NUMERIC(2,0) NOT NULL, VARCHAR(10) NOT NULL, LINE UNITS NUMERIC (9,2) DEFAULT 0.00 NOT NULL, LINE PRICE NUMERIC(9,2) DEFAULT 0.00 NOT NULL, PRIMARY KEY (INV NUMBER,LINE NUMBER), FOREIGN KEY (INV_NUMBER) REFERENCES INVOICE (INV_NUMBER) ON DELETE CASCADE, FOREIGN KEY (P_CODE) REFERENCES PRODUCT(P_CODE), CONSTRAINT LINE_UI1 UNIQUE(INV_NUMBER, P_CODE)); 5. Define the affect the "ON DELETE CASCADE" statement has as shown below. (5 points) CREATE TABLE LINE ( INV_NUMBER LINE NUMBER P CODE INTEGER NOT NULL, NUMERIC(2,0) NOT NULL, VARCHAR(10) NOT NULL, LINE UNITS NUMERIC (9,2) DEFAULT 0.00 NOT NULL, LINE PRICE NUMERIC(9,2) DEFAULT 0.00 NOT NULL, PRIMARY KEY (INV NUMBER,LINE NUMBER), FOREIGN KEY (INV_NUMBER) REFERENCES INVOICE (INV_NUMBER) ON DELETE CASCADE, FOREIGN KEY (P_CODE) REFERENCES PRODUCT(P_CODE), CONSTRAINT LINE_UI1 UNIQUE(INV_NUMBER, P_CODE));
Expert Answer:
Answer rating: 100% (QA)
The SQL code you provided creates a table named LINE In this table there are several columns defined ... View the full answer
Related Book For
Income Tax Fundamentals 2013
ISBN: 9781285586618
31st Edition
Authors: Gerald E. Whittenburg, Martha Altus Buller, Steven L Gill
Posted Date:
Students also viewed these programming questions
-
Milligan's Backyard Storage Kits, a mail order company, sells a variety of backyard storage unit kits and landscaping decorations to its customers. Although the company makes a profit, David...
-
Lord of Chips seeks your advice in measuring its overall cost of capital. The firm is in the 30% tax bracket. You have collected the following information. Sources of Capital Market price New issue...
-
Which of these is NOT one of the validity conditions for a t-test for the slope of a regression line? A. We should have a large sample size, typically n 20. B. The scatterplot of the sample data...
-
Explain how each of the following events would affect the short-run aggregate supply curve. a. An increase in the price level b. An increase in what the price level is expected to be in the future c....
-
Client's Facts: The client found a check written out to cash in the amount of $750. The check was completely made out when he found it. He took it to the bank, signed it on the back as instructed by...
-
Of all 1,672,395 members of the high school class of 2014 who took the SAT (Scholastic Aptitude Test), 793,986 were minority students. Give the relevant proportion using correct notation.
-
In this exercise, you will complete the Property Tax application that you created in Exercise 3 in Chapter 2. a. Use Windows to copy the Tax Solution folder from the VB2017\Chap02 folder to the...
-
1. Briefly describe the Balanced Scorecard approach to control. Explain how it differs from the traditional approach to control used in most companies. 2. Briefly differentiate between active...
-
b. Prepare all consolidating entries needed to prepare consolidated statements for 20X5. (If no entry is required for a transaction/event, select "No journal entry required" in the first account...
-
On March 15, the board of directors of Richmond, Inc, declare a cash dividend of $1 per share. On March15, there are 1,000 shares of stock issued and outstanding. The journal entry required on the...
-
Design a 12" wide rectangular, Class U, prestressed beam. Simply-supported, span length = 30' Material Properties: o Concrete design strength: f'c = 5000 psi o Concrete strength at prestress...
-
Collect data on residential real estate prices within the area you have chosen and graph them (place price on the Y axis and time on the X axis). Graph the longest period of time for which you have...
-
Mira Tech Sdn Bhd is a company specializing in manufacturing electronic gadgets. The company produces and sells a variety of products, including smartphones, tablets, and smartwatches. The management...
-
One vs. Rest SVM 5/5 points (graded) Use the sklearn package and build the SVM model on your local machine. Use random_state = 0, values for other parameters. Available Functions: You have access to...
-
eBook Bank Reconciliation Instructions Amount Descriptions Chart Of Accounts Amount Descriptions Bank Reconciliation Instructions Show Me How 2 Valentine Investigations has the following information...
-
(Drag and drop the missing words) Question 3 In the integral Not yet answered dz Marked out of 7 Va? P Flag question we may use x= and dx= substitutions to reduce the integral to de. This step...
-
Refer to the data for problem 13-36 regarding Long Beach Pharmaceutical Company. Required: Compute each division's residual income for the year under each of the following assumptions about the...
-
Carl and Jenny adopt a Russian orphan. The adoption takes 2 years and two trips to Russia and is final in 2012. They pay $6,000 in 2011 and $7,500 in 2012 of qualified adoption expenses, and have AGI...
-
Jim (age 50) and Martha (age 49) are married with three dependent children. They file a joint return for 2012. Their income from salaries totals $50,000, and they received $10,000 in taxable...
-
The following additional information is available for the Dr. Ivan and Irene Incisor family from Chapters 1 and 2. On September 1, Irene opened a retail store that specializes in sports car...
-
Find the Laplace transform of the following signals and locate the poles and zeros of \(F(s)\). (a) \(f(t)=-8 u(t)\). (b) \(f(t)=0.5 t u(t)\). (c) \(f(t)=10 e^{-20000 t} u(t)\).
-
Find the Laplace transform of \(f(t)=-5 u(t)+5 e^{-5 t}\) \(u(t)-5 t u(t)\). Locate the poles and zeros of \(F(s)\).
-
Find the Laplace transform of \(f(t)=\delta^{\prime}(t)+\delta(t)-e^{-t} u\) \((t)\). Locate the poles and zeros of \(F(s)\).
Study smarter with the SolutionInn App