Purchase Solution

Series of SQL Commands

Not what you're looking for?

Ask Custom Question

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.

Purchase this Solution

Purchase this Solution

Free BrainMass Quizzes
Java loops

This quiz checks your knowledge of for and while loops in Java. For and while loops are essential building blocks for all Java programs. Having a solid understanding of these constructs is critical for success in programming Java.

Javscript Basics

Quiz on basics of javascript programming language.

Word 2010: Tables

Have you never worked with Tables in Word 2010? Maybe it has been a while since you have used a Table in Word and you need to brush up on your skills. Several keywords and popular options are discussed as you go through this quiz.

Basic Computer Terms

We use many basic terms like bit, pixel in our usual conversations about computers. Are we aware of what these mean? This little quiz is an attempt towards discovering that.

Inserting and deleting in a linked list

This quiz tests your understanding of how to insert and delete elements in a linked list. Understanding of the use of linked lists, and the related performance aspects, is an important fundamental skill of computer science data structures.