Task $1$: Create a NONCAT table with the structure shown below.

Field Type Null Key Default

ITEM$\_$ID char$(4)$ NO PRI NULL

DESCRIPTION char$(30)$ YES NULL

ON$\_$HAND int YES NULL

CATEGORY char$(3)$ YES NULL

PRICE decimal$(6,2)$ YES NULL

Task $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.

Task $3$: In the NONCAT table, change the description of item ID DT$12$ to Dog Toy Gift Bonanza.

Task $4$: In the NONCAT table, increase the price of each item in category BRD by $5\%.$

Multiply each price by $1\mathrm{.}05.$

Task $5$: Add the following item to the NONCAT table:

ITEM$\_$ID : FF$17,$

DESCRIPTION : Premium Fish Food,

ON$\_$HAND : $10,$

CATEGORY : FSH$,$

PRICE : $11\mathrm{.}95.$

Task $6$: Delete every item in the NONCAT table for which the category is HOR.

Task $7$: In the NONCAT table, change the category for item UF$39$ to null.

Task $8$: Add a column named ON$\_$HAND$\_$VALUE to the NONCAT table. The on$-$hand value is a seven$-$digit number with two decimal places that represents the product of the number of units on hand and the price. Then set all values of ON$\_$HAND$\_$VALUE to ON$\_$HAND $*$ PRICE.

Task $9$: In the NONCAT table, increase the length of the DESCRIPTION column to $40$ characters.

Task $10$: Remove the NONCAT table from the KimTay Pet Supplies database. From the textbook A Guide to SQL Guide $10$th edition