CS150 Assignment 6, part 2
In the following exercises, you will use the data in the Premier Products database, which is posted on Bb. In each step, use SQL to obtain the desired results. You are to hand in the SQL commands for each step. You can use Access to help complete the steps, or you can simply write the SQL command to complete each step. Create an MS Word document and put the answers to each step in it. Submit this document to Bb along with your database for part 1.
- List the number, name, and zip code of all customers.
- List the complete Part table. Sort the result by part description in ascending order.
- List the number and name of every customer represented by sales rep 35 or 65.
- List the number and name of all customers that are represented by sales rep 35 and have credit limits of $10,000.
- List the number and name of all customers that are represented by sales rep 35 or have credit limits of $10,000.
- List all records of the Customer table where the zip code begins with 333.
- Create a new table named SportingGoods to contain the columns PartNum, Description, OnHand, Warehouse, and Price for all rows in which the item class is SG.
- In the SportingGoods table, change the description of part BV06 to “Fitness Gym”.
- In the SportingGoods table, delete every row in which the price is greater than $1000.
The post [ANSWERED] CS150 Assignment appeared first on My Assignment Online.
