Cashback Offer (20th - 31st October 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 4 | First 10 questions solved

Question posted by
Online Tutor Profile
request

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 your data will not reflect the changes you made in Chapter 3.) If you have access to a DBMS, use the DBMS to perform the tasks and explain the steps you used in the process. If not, explain how you would use SQL to obtain the desired results. Check with your instructor if you are not certain about which approach to take.


1. Create the TopLevelCust view described in Review Question 2. Display the data in the view.
2. Create the PartOrder view described in Review Question 3. Display the data in the view.
3. Create a view named OrdTot. It consists of the order number and order total for each order currently on file.(The order total is the sum of the number ordered multiplied by the quoted price on each order line for each order.) Display the data in the view.
4. Create the following indexes. If it is necessary to name the index in your DBMS, use the indicated name.
a. Create an index named PartIndex1 on the PartNum field in the OrderLine table.
b. Create an index named PartIndex2 on the Warehouse field in the Part table.
c. Create an index named PartIndex3 on the Warehouse and Class fields in the Part table.
d. Create an index named PartIndex4 on the Warehouse and OnHand fields in the Part table and list units on hand in descending order.
5. Drop the PartIndex3 index.
6. Assume the Part table has been created, but there are no integrity constraints. Create the necessary integrity constraint to ensure that the only allowable values for the Class field are AP, HW, and SG. Ensure that the PartNum field is the primary key and that the PartNum field in the OrderLine table is a foreign key that must match the primary key of the Part table.
7. Add a field named Allocation to the Part table. The allocation is a number representing the number of units of each part that have been allocated to each customer. Set all Allocation values to zero. Calculate the number of units of part number KV29 currently on order. Change the Allocation value for part number KV29 to this number.Display all the data in the Part table.
8. Increase the length of the Warehouse field in the Part table to two characters. Change the warehouse number for warehouse 1 to 1a. Display all the data in the Part table.
9. Delete the Allocation field from the Part table. Display all the data in the Part table.
10. What command would you use to delete the Part table from the Premiere Products database? (Do not delete the Part table.)
11. Write a stored procedure that will change the price of a part with a given part number. How would you use this stored procedure to change the price of part AT94 to $26.95?
12. Write the code for the following triggers following the style shown in the text.
a. When adding a customer, add the customer’s balance times the sales rep’s commission rate to the commission for the corresponding sales rep.
b. When updating a customer, add the difference between the new balance and the old balance multiplied by the sales rep’s commission rate to the commission for the corresponding sales rep.
c. When deleting a customer, subtract the balance multiplied by the sales rep’s commission rate from the
commission for the corresponding sales rep.
13. If you are using Access 2010, create the following data macros.
a. Create a data macro associated with the After Insert event for the Customer table to implement the trigger in Step 12a. Test the data macro by adding a customer and ensuring that the corresponding sales rep’s commission is updated correctly.
b. Create a data macro associated with the After Update event for the Customer table to implement the trigger in Step 12b. Test the data macro by changing a customer’s balance and ensuring that the corresponding sales rep’s commission is updated correctly.

Available Answer
$ 18.00

[Solved] Premiere Products Exercise Chapter 4 | First 10 questions solved

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