Create a trigger for the invoices table in the ap database that automatically inserts the vendor name for a paid invoice into a table named transactionsdone. the trigger should fire any time the paymenttotal column of the invoices table is updated. by updated, this means the value in the update query is different from the current value in the database. if the two values are the same, then no insert should be made into the transactionsdone table. also, make sure you add the current date using the getdate() function into the transactionsdone table. the structure of the transactiondone table is as follows: create table transactionsdone(vendorname varchar(50),currentdate datetime2)

3.12: the speed of sound the speed of sound depends on the material the sound is passing through. below is the approximate speed of sound (in feet per second) for air, water and steel: air: 1,100 feet per second water: 4,900 feet per second steel: 16,400 feet per second write a program class the speed of sound that asks the user to enter “air”, “water”, or “steel”, and the distance that a sound wave will travel in the medium. the program should then display the amount of time it will take. you can calculate the amount of time it takes sound to travel in air with the following formula: time = distance/1,100 you can calculate the amount of time it takes sound to travel in water with the following formula: time = distance/4,900 you can calculate the amount of time it takes sound to travel in steel with the following formula: time = distance/16,400