Question: Use MyGuitarShop DB: Create a stored procedure called spFinal that given a ProductID does the following: 1 . If the Product doesn t exist, display

Use MyGuitarShop DB:
Create a stored procedure called spFinal that given a ProductID does the following:
1. If the Product doesnt exist, display a mesage. e.g. "Product doesn't exist" 2. If the Product hasnt been ordered display a message e.g.There are no orders for ibanez.3. Otherwise, return all the orders for that product and display a message saying how many units of that product have been sold.4. Return the number of units sold for that product as an output parameter.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Programming Questions!

Q:

Introduction to databases FALL 20 Assignment III Based on the database schema that was used in assignment I, answer the following questions: 1. Write the business rules that are reflected by the...

Q:

Introduction to databases Assignment 1 Description of the schema The following database is used by a building materials company to edit invoices for its customers and to manage its inventory The...

Q:

WiL Activity 5: Write SQL for a TV Guide Module 1: Design a database schema to hold information for a TV guide. Call the database TVGuide. Each TV show must have a title, a description, a...

Q:

I need some help and explanation will be a text-based .cpp file including your C++ program and a text-based .sql file including your Oracle stored procedures for the Database Application ....

Q:

Data Management and Data Analytics . Objective of the project . Base SAS Programming Using SAS Studio on SAS Viya C. SAS Visual Data Mining and machine Learning (In some questions Base SAS...

Q:

Database Administration CHAPTER OBJECTIVES I Understand the need for and importance of database I ttno'illI the meaning of ACID transaction administralin - Learn the tour 1992 ANSI standard isolation...

Q:

The Language is Java. Please post code for the following steps 17-23. Thank You in advance. Scenario - OraclProduction OraclProduction Ltd are specialists in producing production line manufacturing...

Q:

In a school, the Personnel Department is responsible for storing details about all staff who work for the school. There are four categories of staff: management teacher support staff maintenance and...

Q:

please help me to solve this problem. this is the description: this is the input file: this is the output: Description: Abdul Latif Jameel (ALJ) - Toyota is one of the leading entities in the...

Q:

Controller, Judy Koch, in a recent speech said, "I rarely see a real variable cost or a truly fixed cost." What did she mean? Include in your response an explanation of the difference in behavior of...

Q:

The Global Dimension How does prohibiting the importing of goods that infringe U.S patents protect those patents outside the United States?

Q:

Should U.S. companies like Microsoft, Dell, and Hewlett-Packard be held responsible for working conditions in foreign factories that they do not own, but where subcontractors make products for them?

Q:

4. (True/False): The Str_copy procedure prevents a string from being copied into too small a memory area.

Q:

Student government members survey every 15th student who enters the school building and asks whether students favor the school s new school mascot The sample statistics show that 57 oppose the new...