Question: Exercise 15-6 [20 points] Create a trigger named Products_UPDATE that checks the new value for the DiscountPercent column of the Products table. This trigger should

Exercise 15-6 [20 points] Create a trigger named Products_UPDATE that checks the new value for the DiscountPercent column of the Products table. This trigger should raise an appropriate error if the discount percent is greater than 100 or less than 0.

If the new discount percent is between 0 and 1, this trigger should modify the new discount percent by multiplying it by 100. That way, a discount percent of .2 becomes 20.

Test this trigger with an appropriate UPDATE statement.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

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

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

Chapter 15 How to code stored procedures, functions, and triggers Exercises 1. Write a script that creates and calls a stored procedure named spInsertCategory. First, code a statement that creates a...

1 . Write a script that creates a stored procedure named spInsertCategory. The procedure should accept one parameter for a category name, which it uses to add a new row to the Categories table. In...

Exercise 15-8 [20 points] Create a table named ProductsAudit. This table should have all columns of the Products table, except the Description column. Also, it should have an AuditID column for its...

You will use SQL and My Guitar Shop database to create SQL statements. Save your select statements as a script. Place the semicolon at the end of each SQL statement. Please number your answers from 1...

creating a sql for the guitar shop You will use SQL and My Guitar Shop database to create SQL statements. Save your select statements as a script. Place the semicolon at the end of each SQL...

1 . Write a script that creates and calls a stored procedure named insert _ category. First, code a statement that creates a procedure that adds a new row to the Categories table. To do that, this...

Create a trigger named Products_UPDATE that checks the new value for the DiscountPercent column of the Products table. This trigger should raise an appropriate error if the discount percent is...

Exercise 15-7 [10 points] Create a trigger named Products_INSERT that inserts the current date for the DateAdded column of the Products table if the value for that column is null. Test this trigger...

Using SQL Server Create an INSTEAD OF trigger named Products_UPDATE that error checks the updated value of DiscountPercent column of the Products table. If the discount percent is less than 0 or...

On January 4, 2015, Pronti Company acquired all of the net assets of Scott Company for $ 120,000 cash. The statements of financial position for each company prior to the acquisition follow: Required:...

Discuss in scholarly detail the model of grand strategy clusters.

Which of the following statements is CORRECT? A bond's coupon is equal to its face value. All else equal, if a bond's yield to maturity increases, its price will fall. If a bond's yield to maturity...

CT Corp Comprehensive Question Canadian Tire Corporation, Limited (Canadian Tire) is a family of companies that includes a retail segment and a financial services division, among others. The retail...

6. Explain the power of labels.

1. Regional Language Variations. Meet in small groups with other class members and discuss variations in language use in different regions of the United States (accent, vocabulary, and so on)....

10. Discuss the complexities of language policies.