Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Seven Databases In Seven Weeks A Guide To Modern Databases And The NoSQL Movement

Authors: Luc Perkins, Eric Redmond, Jim Wilson

2nd Edition

1680502530, 978-1680502534

More Books

Students also viewed these Databases questions