Question: Write the code for the following triggers following the style shown in the text. a. When adding a customer, add the customers balance times the

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.

Step by Step Solution

★★★★★

3.38 Rating (164 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock

a DELIMITER CREATE TRIGGER AddCustomer AFTER INSERT ON C... View full answer

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Document Format (1 attachment)

671-CS-DB (977).docx

120 KBs Word File

Students Have Also Explored These Related Databases Questions!

1. Create a view named LargeSlip using the data in the MarinaNum, SlipNum, RentalFee, BoatName, and OwnerNum columns in the MarinaSlip table for those slips with lengths of 40 feet. Display the data...

Assume the Branch table contains a column called TotalValue that represents the total price for all books at that branch. Following the style shown in the text, write the code for the following...

For the following code sequences and the timing parameters for the two implementations in Figure 4.38, compute the total stall cycles for the base MSI protocol and the optimized MOSI protocol in...

Chapter 8 ( A Guide to SQL ) Use the KimTay Pet Supplies database only. You must use Oracle. Case Exercises: Odd numbers, pg . 2 8 4 - 2 8 5 . KimTay Pet Supplies Use the KimTay Pet Supplies database...

VIEW THE STEP-BY-STEP SOLUTION TO: Title: ABC Appliance Inherent Risk and Control Design Assessment Prepare Inherent Risks and Control Design Assessment. This course project/case... I.Title: ABC...

CHA P TER 9 Understanding Software: A Primer for Managers 1. INTRODUCTION L E A R N I N G O B J E C T I V E S 1. Recognize the importance of software and its implications for the rm and strategic...

Rev.Confirming Pages C H A P T E R 7 Planning, Composing, and Revising Chapter Outline The Ways Good Writers Write Activities in the Composing Process Using Your Time Effectively Brainstorming,...

Hi need to get done only one article from the given ones but please choose any one except article no 2 as i have already done that one. please choose right theory and apply it on the article and...

I would like assist for my assessment. The subject is Subsidiary Accounts and Ledgers and Foundation Skills. T-1.8.1 Details of Assessment Term and Year 1, 2017 Time allowed Week 2-7 Assessment No 1...

You are a public official elected at the local city level who serves a population of 50,000 to 250,000 people. A budget of 10 million dollars has been allocated to you by the city manager, and you...

Two years ago Abebe organized start Laundromat as a sole proprietorship. At December 31, 2016, the end of current fiscal year, the trial balance of start Laundromat is as follows: Start Laundromat...

Can you explain how a computer processes data?

________ should handle content complaints . a. Product teams b. Content care teams c. Content teams

Which of the following allows you to get more information from the same amount of data? a. Creating a healthy relational database b. Entering the same information more than once c. Using a flat file...

Which of the following describes database design? a. Collecting the large volume of data produced by digital processes and devices b. Creating a file used to store data about a single entity c....

What table might the database need to help determine the balance field in the Patient table? Would you want to record when a bill is paid and the amount? How would the insurance part of the bill be...

Kelley's Baskets makes handmade baskets for distribution to upscale retail outlets. The firm is currently considering making handmade wreaths as well. Which one of the following is the best example...

Company A desires a fixed-rate, long-term loan. Company A presently has access to floating interest rate funds at a margin of 1.5% over LIBOR. Its direct borrowing cost is 13% in the fixed-rate bond...

1 . Huffman Code / bit representation Table of AAAAAABBCCDDEEFFFFF. a ) Fix bit representation ( points: 1 ) b ) Variable bit representation ( points: 1 ) 2 . Huffman Tree of AAAAAABBCCDDEEFFFFF (...