Premiere Products Exercise Chapter 3 | Complete Solution
- ExpertT
- Rating : 109
- Grade : A+
- Questions : 1
- Solutions : 1026
- Blog : 0
- Earned : $53187.54
Premiere Products Exercises
In the following exercises, you will use the data in the Premiere Products database shown in Figure 2-1 in Chapter
2. (If you use a computer to complete these exercises, use a copy of the original Premiere Products database so
you will still have the original data when you complete Chapter 4.) In each step, use SQL to obtain the desired
results. You can use a DBMS to complete the exercises using a computer, or you can simply write the SQL command
to complete each step. Check with your instructor if you are uncertain about which approach to take.
1. List the number and name of all customers.
2. List the complete Part table.
3. List the number and name of every customer represented by sales rep 35.
4. List the number and name of all customers that are represented by sales rep 35 and that have credit limits of
$10,000.
5. List the number and name of all customers that are represented by sales rep 35 or that have credit limits of
$10,000.
6. For each order, list the order number, order date, number of the customer that placed the order, and name of
the customer that placed the order.
7. List the number and name of all customers represented by Juan Perez.
8. How many orders were placed on 10/20/2013?
9. Find the total of the balances for all customers represented by sales rep 35.
10. Give the part number, description, and on-hand value (OnHand * Price) for each part in item class HW.
11. List all columns and all rows in the Part table. Sort the results by part description.
12. List all columns and all rows in the Part table. Sort the results by part number within item class.
13. List the item class and the sum of the number of units on hand. Group the results by item class.
14. 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.
15. In the SportingGoods table, change the description of part BV06 to “Fitness Gym.”
16. In the SportingGoods table, delete every row in which the price is greater than $1,000.
[Solved] Premiere Products Exercise Chapter 3 | Complete Solution
- This Solution has been Purchased 6 time
- Average Rating for this solution is A+
- Submitted On 28 Feb, 2015 08:17:31
- ExpertT
- Rating : 109
- Grade : A+
- Questions : 1
- Solutions : 1026
- Blog : 0
- Earned : $53187.54
This Tutorial is rated A+ p...
Premiere Products Exercise Chapter 5 | Complete Solution
The following exercises are based on the Premiere Products database.
1. Using your knowledge of Premiere Products, determine the functional dependencies that exist in the following table. After determining the functio...
Premiere Products Exercise Chapter 4 | First 10 questions solved
This Tutorial is rated A+ previously,if you have any questions regarding this tutorial than you can contact me.
...Premiere Products Exercise Chapter 2 | Complete Solution
In the following exercises, you will use the data in the Premiere Products database shown in Figure 2-1. (If you use a computer to complete these exercises, use a copy of the Premiere Products database so you will still ha...
Premiere Products Exercise Chapter 1 | Complete Solution
Communication time = access delay +(data volume / transmission rate)
Communication time = 2.5 + (5000 * 1000 /50000)
= 2.5 + (5000000/50000)
= 2.5 + (100) =&nbs...
Premiere Products Exercise Chapter 9 | Complete Solution
1. Fragment the Customer table so that customers of rep 20 form a fragment named CustomerRep20, customersof rep 35 form a fragment named CustomerRep35, and customers of rep 65 form a fragment named CustomerRep65. (Include ...