Question
PL/SQL project. please show me all steps. Run the script, C9_BBcreate.sql, to create the tables required for this lab. Create a table named BB_SALES_SUM that
PL/SQL project. please show me all steps.
Run the script, C9_BBcreate.sql, to create the tables required for this lab. Create a table named BB_SALES_SUM that holds the product ID, total sales in dollars, and the total quantity sold for each product. Create a trigger named BB_SALESUM_TRG that updates the BB_SALES_SUM accordingly when an order is confirmed or the ORDERPLACED column in the BB_BASKET table is updated to 1. Test your trigger with the following basket IDs: 14, 15, and 16. Create a folder named, fullname_lab11. Copy your source codes and the output file to the folder. Zip the folder and upload it to Blackboard.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started