Explore BrainMass

Series of SQL Commands

See attach file for data and details.

Use SQL to make the following changes to the Premiere Products database. After each change, execute an appropriate query to show that the change was made correctly.

1. Use the following information to create a new table named NON_SP_GOOD.*see attachment*

2. Insert into the NON_SP_GOOD table the part number, part description, number of units on hand, item class, and unit price from the PART table for each part that is not in item class SG.

3. In the NON_SP_GOOD table, change the description of part number AT94 to "Deluxe Iron."

4. In the NON_SP_GOOD table, increase the price of each item in item class HW by 2%. (Hint: Multiply each price by 1.02.)

5. Add the following part to the NON_SP_GOOD table: part number: LJ28; description: Electric Razor; number of units on hand: 21; class: AP; and price: 39.95.

6. Delete every part in the NON_SP_GOOD table for which the class is HW.

7. In the NON_SP_GOOD table, change the class for part KL62 to null.

8. Add a column named ON_HAND_VALUE to the NON_SP_GOOD table. The allocation is a seven-digit number with two decimal places, representing the product of the number of units on hand and the price. Then set all values of ON_HAND to ON_HAND * PRICE.

9. In the NON_SP_GOOD table, increase the length of the PART_DESCRIPTION column to 30 characters.

10. Delete the NON_SP_GOOD table from the Premiere Products database.