Create the PROD_SALES_SUM_SP procedure to update the BB_PROD_SALES table, which holds total sales dollars and total sales quantity by product ID, month, and year. The order date should be used for the month and year information. Create the SHOP_SALES_SUM_SP procedure to update the BB_SHOP_SALES table, which holds total dollar sales by shopper ID. The total should include only product amounts—no shipping or tax amounts. The BB_SHOP_SALES and BB_PROD_SALES tables have already been created. Use the DESCRIBE command to review their table structures. Run pl/sql block to execute and present results for both procedures.
Create the PROD_SALES_SUM_SP procedure to update the BB_PROD_SALES table, which holds total sales dollars and total sales quantity by product ID, month, and year. The order date should be used for the month and year information. Create the SHOP_SALES_SUM_SP procedure to update the BB_SHOP_SALES table, which holds total dollar sales by shopper ID. The total should include only product amounts—no shipping or tax amounts. The BB_SHOP_SALES and BB_PROD_SALES tables have already been created. Use the DESCRIBE command to review their table structures. Run pl/sql block to execute and present results for both procedures.
Chapter6: Additional Database Objects
Section: Chapter Questions
Problem 6HOA: A new table has been requested to support tracking automated emails sent to customers. Create the...
Related questions
Question
- The Reporting and Analysis Department has a
database containing tables that hold summarized data to make report generation simpler and more efficient. They want to schedule some jobs to run nightly to update summary tables. Create two procedures to update the following tables (assuming that existing data in the tables is deleted before these procedures run):
Create the PROD_SALES_SUM_SP procedure to update the BB_PROD_SALES table, which holds total sales dollars and total sales quantity by product ID, month, and year. The order date should be used for the month and year information.
Create the SHOP_SALES_SUM_SP procedure to update the BB_SHOP_SALES table, which holds total dollar sales by shopper ID. The total should include only product amounts—no shipping or tax amounts.
The BB_SHOP_SALES and BB_PROD_SALES tables have already been created. Use the DESCRIBE command to review their table structures. Run pl/sql block to execute and present results for both procedures.
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution!
Trending now
This is a popular solution!
Step by step
Solved in 2 steps with 2 images
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.Recommended textbooks for you
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781285196145
Author:
Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel
Publisher:
Cengage Learning
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781305627482
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781285196145
Author:
Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel
Publisher:
Cengage Learning
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781305627482
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning