ComputerScienceExpert

(11)

$18/per page/

About ComputerScienceExpert

Levels Tought:
Elementary,Middle School,High School,College,University,PHD

Expertise:
Applied Sciences,Calculus See all
Applied Sciences,Calculus,Chemistry,Computer Science,Environmental science,Information Systems,Science Hide all
Teaching Since: Apr 2017
Last Sign in: 103 Weeks Ago, 3 Days Ago
Questions Answered: 4870
Tutorials Posted: 4863

Education

  • MBA IT, Mater in Science and Technology
    Devry
    Jul-1996 - Jul-2000

Experience

  • Professor
    Devry University
    Mar-2010 - Oct-2016

Category > Programming Posted 08 May 2017 My Price 8.00

Create a trigger named Products_UPDATE

Please look at the following attached document that has question # 6 and 8 from Chapter 15 MyGuitarShop SQL exercise. 

 

My Guitar Shop exercises.docxMurach’s SQL Server 20126. Create a trigger named Products_UPDATE that checks the new value for the DiscountPercent columnof the Products table. This trigger should raise an appropriate error if the discount percent is greaterthan 100 or less than 0.If the new discount percent is between 0 and 1, this trigger should modify the new discount percent bymul±plying it by 100. That way, a discount percent of .2 becomes 20.Test this trigger with an appropriate UPDATE statement.8. Create a table named ProductsAudit. This table should have all columns of the Products table, exceptthe Descrip±on column. Also, it should have an AuditID column for its primary key, and the DateAddedcolumn should be changed to DateUpdated.Create a trigger named Products_UPDATE. This trigger should insert the old data about the product intothe ProductsAudit table aFer the row is updated.Then, test this trigger with an appropriate UPDATE statement.This lists the original columns on the Products table.

Attachments:

Answers

ComputerScienceExpert
(11)
Status NEW Posted 08 May 2017 07:05 AM My Price 8.00

-----------

Attachments

file 1494227414-Solutions file 2.docx preview (51 words )
H-----------ell-----------o S-----------ir/-----------Mad-----------am ----------- Th-----------ank----------- yo-----------u f-----------or -----------you-----------r i-----------nte-----------res-----------t a-----------nd -----------buy-----------ing----------- my----------- po-----------ste-----------d s-----------olu-----------tio-----------n. -----------Ple-----------ase----------- pi-----------ng -----------me -----------on -----------cha-----------t I----------- am----------- on-----------lin-----------e o-----------r i-----------nbo-----------x m-----------e a----------- me-----------ssa-----------ge -----------I w-----------ill----------- be----------- qu-----------ick-----------ly -----------onl-----------ine----------- an-----------d g-----------ive----------- yo-----------u e-----------xac-----------t f-----------ile----------- an-----------d t-----------he -----------sam-----------e f-----------ile----------- is----------- al-----------so -----------sen-----------t t-----------o y-----------our----------- em-----------ail----------- th-----------at -----------is -----------reg-----------ist-----------ere-----------d o-----------n -----------THI-----------S W-----------EBS-----------ITE-----------. ----------- Th-----------ank----------- yo-----------u -----------
Not Rated(0)