1. Create a NONCAT table with the structure shown in Figure 6-28. Figure 6-28 NONCAT Table...

Transcribed Image Text:

1. Create a NONCAT table with the structure shown in Figure 6-28. Figure 6-28 NONCAT Table Layout NONCAT COLUMN ITEM_ID DESCRIPTION ON_HAND CATEGORY PRICE TYPE CHAR CHAR DECIMAL CHAR DECIMAL LENGTH DECIMAL PLACES 4 30 4 3 6 0 2 NULLS ALLOWED? No DESCRIPTION Item ID (primary key) Item description Number of units on hand Item category Unit price 2. Insert into the NONCAT table the item ID, description, number of units on hand, category, and unit price from the ITEM table for each item that is not in category CAT. 1. Create a NONCAT table with the structure shown in Figure 6-28. Figure 6-28 NONCAT Table Layout NONCAT COLUMN ITEM_ID DESCRIPTION ON_HAND CATEGORY PRICE TYPE CHAR CHAR DECIMAL CHAR DECIMAL LENGTH DECIMAL PLACES 4 30 4 3 6 0 2 NULLS ALLOWED? No DESCRIPTION Item ID (primary key) Item description Number of units on hand Item category Unit price 2. Insert into the NONCAT table the item ID, description, number of units on hand, category, and unit price from the ITEM table for each item that is not in category CAT.

Answer rating: 100% (QA)

Step 1 1 CREATE TABLE NONCAT 3 2 ITEMID CHAR4 NOT NULL DESCRIPTION CHAR30 4 ONH... View the full answer