Cashback Offer (20th - 30th September 2020). Get Flat 10% Cashback credited in your account on a minimum transaction of $80. Post Your Question

Question DetailsNormal
$ 18.00

Premiere Products Exercise Chapter 2 | Complete Solution

Question posted by
Online Tutor Profile
request

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 have the original data when you complete Chapter 3.) In each step, use QBE to obtain the desired results. You can use the query feature in a DBMS to complete the exercises using a computer, or you can simply write a description of how you would complete the task. 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 all customers represented by sales rep 35.
4. List the number and name of all customers that are represented by sales rep 35 and that have a credit limit of $10,000.
5. List the number and name of all customers that are represented by sales rep 35 or that have a credit limit 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 customers have a credit limit of $10,000?
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 records in the Part table. Sort the results by part description.
12. List all columns and all records in the Part table. Sort the results by part number within item class.
13. List the item class and the sum of the value of parts on hand. Group the results by item class.

Available Answer
$ 18.00

[Solved] Premiere Products Exercise Chapter 2 | Complete Solution

  • This Solution has been Purchased 2 time
  • Average Rating for this solution is A+
  • Submitted On 28 Feb, 2015 09:04:38
Answer posted by
Online Tutor Profile
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...

Buy now to view the complete solution
Other Similar Questions
User Profile
Exper...

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...

User Profile
Exper...

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.

...
User Profile
Exper...

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...

User Profile
Exper...

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...

User Profile
Exper...

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 ...

The benefits of buying study notes from CourseMerit

homeworkhelptime
Assurance Of Timely Delivery
We value your patience, and to ensure you always receive your homework help within the promised time, our dedicated team of tutors begins their work as soon as the request arrives.
tutoring
Best Price In The Market
All the services that are available on our page cost only a nominal amount of money. In fact, the prices are lower than the industry standards. You can always expect value for money from us.
tutorsupport
Uninterrupted 24/7 Support
Our customer support wing remains online 24x7 to provide you seamless assistance. Also, when you post a query or a request here, you can expect an immediate response from our side.
closebutton

$ 629.35