Question: SQL statements, needing help please. 6-1 Create a table named NONCAT in the KIMTAY database with the following structure. Size 4 30 Other Primary Key

SQL statements, needing help please.

SQL statements, needing help please. 6-1 Create a table named NONCAT inthe KIMTAY database with the following structure. Size 4 30 Other Primary

6-1 Create a table named NONCAT in the KIMTAY database with the following structure. Size 4 30 Other Primary Key Column Name ITEM ID DESCRIPTION ON HAND CATEGORY PRICE Type CHAR CHAR INT CHAR DECIMAL 3 5,2 6-1 SOL STATEMENT: Answer: 6-1 RESULTS: (Use DESCRIBE statement) 6-2 Insert into 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 the category CAT. 6-2 SQL STATEMENT : Answer: 6-2 Results: (Use SELECT * statement) SELECT * FROM NONCAT: 6-3 Change in the NONCAT table, change the description of item ID DT12 to "Dog Toy Gift Bonanza." 6-3 SQL STATEMENT : Answer: (Use SELECT statement) 6-3 Results: SELECT * FROM NONCAT: 6-4 In the NONCAT table, increase the price of each item in category BRD by five percent. (Hint: Multiply each price by 1.05.) 6-4 SQL STATEMENT : Answer: 6-4 Results: (Use SELECT statement)

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock 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 Databases Questions!