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
-
Calculate the following using the appropriate functions in Excel: 1. Find the NPV and IRR of a project with the following cash flows and a 12% cost of capital. Also calculate the MIRR assuming a...
-
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...
-
Behar Company makes three types of stainless steel frying pans. Each of the three types of pans requires the use of a special machine that has total operating capacity of 182,000 hours per year....
-
In Section 8.6. 1, it is shown that without sequence numbers, Trudy (a woman- in-the middle) can wreak havoc in an SSL session by interchanging TCP segments. Can Trudy do something similar by...
-
Consider the experiment discussed in Example 3.10 of tossing a coin 10 times. Show how we found that there were 210 = 1,024 sample points for this experiment. LO5
-
Dearborn Manufacturing, Co. completed the following transactions during 2014: Jan. 16 Declared a cash dividend on the 6%, $ 95 par noncumulative preferred stock (1,000 shares outstanding). Declared a...
-
Dalton is a major department store chain. Its stock has a beta of 1.35, the risk-free rate is 3 percent and the required rate of return on the market is 8 percent. A. What is the market risk premium?...
-
Presented below is an aging schedule for Bryan Company at December 31, 2021. At December 31, 2021, the unadjusted balance in Allowance for Doubtful Accounts is a credit of $8,000. Instructions a....
-
Parallelogram Rectangle Rhombus O Square Question 2 Determine the most precise name for the quadrilateral.
-
Why is it critical to immediately contact your Engagement Partner when you suspect or identify non-compliance? He or she will ensure that the non-compliance doesn't affect the Client's reputation He...
-
Question 9: Determine the current and its direction, in each resistor, for the circuit shown below. Show your calculations. R=152 9.0 V + 12V ww R=75 2 R3= 50
-
how can The High - Tech Way To Recycle Clothes sustainable. and what they offer and what are their ecofriendly
-
James Bondbuyer purchases a Treasury bond on Monday, May 2, regular way settlement. The bond pays interest on January 15 and July 15. How many days of accrued interest will be owed to the seller? A...
-
Aviation and air traffic control have come a long way in the last 100-years. Some believethat we have reached a plateau and that growth in aviation will stop. Aviation may go the way of the railroads...
-
Sunland Company orded succles.co ad d ed the would be for the Athen the coo l had the c o untry to be debit Supplies $1900, cred Supples $1900 debut ples, $1800 credit Supplies Experse 1800 det...
-
A firm has the following balance sheet: Assets Cash Accounts receivable Inventory Plant and equipment $ 15,000 150,000 92,000 170,000 $427,000 Liabilities and Equity Accounts payable Long-term debt...
-
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...
-
Research new software products that assist in communications management for large projects. Write a short paper summarizing your findings. Include Web sites for software vendors and your opinion of...
-
Review the following scenarios, and then write a paragraph for each one describing what media you think would be most appropriate to use and why. See Table 10-2 for suggestions. a. Many of the...
-
Review the templates for various project documents provided in this chapter. Pick one of them and apply it to a project of your choice. Make suggestions for improving the template. LO.1
![Mobile App Logo](https://dsd5zvtm8ll6.cloudfront.net/includes/images/mobile/finalLogo.png)
Study smarter with the SolutionInn App