We are using, Oracle Database 11g Express Edition, Using SQL. Thank you.

Use SQL to make the following changes to the TAL Distributors database (see Figure 1-2 in Chapter 1). After each change, execute an appropriate query to show that the change was made correctly. If directed to so so by your instructor, use the information provided with the Chapter 3 Exercises to print your output to save it to a document. 1. Create a NONGAME table with the structure shown in Figure 6-28.

2. Insert into the NONGAME table the item number, description, number of units on hand, category, and unit price from ITEM table for each item that is not in category GME.

3. In the NONGAME table, change the description of the item number DL51 TO "Classic Train Set"

4. In the NONGAME table, increase the price of each item in category TOY by two percent. (Hint: Multiply each price by 1.02.)

NON GAME Length Decimal Places Nulls Allowed? Description Column Type ITEM NUM Item number (primary key DESCRIPTION CHAR Item description DECIMAL ON HAND Number of units on hand CATEGORY CHAR Item category DECIMAL Unit price PRICE FIGURE 6-28 NONGAME table layout