Triggers In the database ProductOrders created in the previous exercise, create the following triggers: 1. Trigger...

Transcribed Image Text:

Triggers In the database "ProductOrders" created in the previous exercise, create the following triggers: 1. Trigger to print a message "N customers are successfully inserted" when some customers are inserted into the Customers table, where N is the number of inserted customers. 2. Trigger for the insertion of a product into an order (insert into Orderltems), if SellPrice < Price then do not allow the insertion (use after or for in this trigger). 3. Trigger for the update of SellPrice in OrderItems, if SellPrice < Price, then do not allow the update (use instead of in this trigger). 4. Trigger for the insertion of a product into an order (insert into OrderItems): a. If Quantity > StockQuantity, then refuse the insertion. b. If Quantity <= StockQuantity, then update the StockQuantity of the corresponding product (StockQuantity = StockQuantity - Quantity) 5. Trigger for the update of Quantity in OrderItems: a. If the StockQuantity is not enough after the update, then refuse the update b. If the StockQuantity is enough after the update, then update the StockQuantity of the corresponding Product. 6. Trigger for the insertion of a product into an order (insertion into OrderItems): a. Update the Discount of the corresponding row in Orderltems table. b. Update the Amount of the corresponding order in Orders table. 7. Trigger for the update of OrderItems: a. Update the quantity of product in Products table. b. Update the Amount of the corresponding order in Orders table. Triggers In the database "ProductOrders" created in the previous exercise, create the following triggers: 1. Trigger to print a message "N customers are successfully inserted" when some customers are inserted into the Customers table, where N is the number of inserted customers. 2. Trigger for the insertion of a product into an order (insert into Orderltems), if SellPrice < Price then do not allow the insertion (use after or for in this trigger). 3. Trigger for the update of SellPrice in OrderItems, if SellPrice < Price, then do not allow the update (use instead of in this trigger). 4. Trigger for the insertion of a product into an order (insert into OrderItems): a. If Quantity > StockQuantity, then refuse the insertion. b. If Quantity <= StockQuantity, then update the StockQuantity of the corresponding product (StockQuantity = StockQuantity - Quantity) 5. Trigger for the update of Quantity in OrderItems: a. If the StockQuantity is not enough after the update, then refuse the update b. If the StockQuantity is enough after the update, then update the StockQuantity of the corresponding Product. 6. Trigger for the insertion of a product into an order (insertion into OrderItems): a. Update the Discount of the corresponding row in Orderltems table. b. Update the Amount of the corresponding order in Orders table. 7. Trigger for the update of OrderItems: a. Update the quantity of product in Products table. b. Update the Amount of the corresponding order in Orders table.

Answer rating: 100% (QA)

SOLUTION1 Givendat We are create a trigger on ride table when return time is changed to an earlier time Please insert a message into parkmessage table for each customer who has unused reservation stat... View the full answer