Use SQL Workbench. Module 6 KimTay Pet Supplies.

Use the table below for the questions:

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

7. In the NONCAT table, change the category for item UF39 to null.

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.

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

10. Remove the NONCAT table from the KimTay Pet Supplies database.

NONCAT FIGURE 6-28 NONCAT table layout