Question: 5. Define the affect the ON DELETE CASCADE statement has as shown below. (5 points) CREATE TABLE LINE ( INV_NUMBER LINE NUMBER P CODE

5. Define the affect the  

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));

Step by Step Solution

3.39 Rating (155 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock

The SQL code you provided creates a table named LINE In this table there are several columns defined ... View full answer

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 Programming Questions!