Question: Create a table UserChoice(p#, price) to store information about products (number and price) selected by a user. Leave the table UserChoice empty when first created.

Create a table UserChoice(p#, price) to store information about products (number and price) selected by a user. Leave the table UserChoice empty when first created.

Implement a stored PL/SQL procedure FindProducts(category, keyword) that finds all products categorized by the input parameter category and described by the input parameter keyword. For example, Find Products('book', 'database') will find all books that are described or related to 'database'. The procedure is to store the numbers and prices of all selected products in UserChoice table. Consider the following categories of products - book, video and cdrom when you test your procedure.

To test your procedure,

(i) implement SQL script that displays the contents of empty UserChoice table,

(ii) execute CREATE OR REPLACE PROCEDURE statement to store Find Products in a data dictionary, and

(iii) execute a stored procedure Find Products again to display the contents of nonempty UserChoice table.

Step by Step Solution

★★★★★

3.55 Rating (165 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock

Create UserChoice table CREATE TABLE UserChoice p INT price DECIMAL102 Implement stored PLSQL pr... View full answer

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 Databases Questions!

To demonstrate the ability to propose, implement, and query the database. Problem: MovinOn Inc. is a moving company that provides moving and storage services in California, Nevada, and Arizona....

Planning is one of the most important management functions in any business. A front office managers first step in planning should involve determine the departments goals. Planning also includes...

You are required to write a Python program that will manage character (heroes and villain) information. Character (hero and villain) information will be stored in a text file that will be read in...

A creative engineer suggests structuring the TLB so that not all the bits of the presented address need match to result in a hit. Suggest how this might be achieved, and what might be the costs and...

// java //1.Class Q3_Ticket_manager package ticket; import java.util.TreeMap; public class Q3_Ticket_Manager { public static void main(String[] args) { new Q3_Ticket_Manager().manage(); } //...

Lesson 12 Quiz (Show/Explain all Work) IST 230 Relations on Sets, Databases 1. Let A = {0, 1, 2, 3, 4, 5, 6, 7, 8} and B = {1, 2, 3, 4, 5, 6, 7, 8}. Now let R be a binary relation R from A to B such...

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 ....

Use the formulae bellow to find ROCE for HOME DEPOT using there 10-k. ROCE = RNOA + LEVERAGE * (RNOA - NET BORROWING COST) 10-K bellow:- Table of Contents UNITED STATES SECURITIES AND EXCHANGE...

Two equal-sized newspapers have overlap circulation of 10%(10%of the subscribers subscribe to both newspapers). Advertisers are willing to pay $10 to advertise in one newspaper but only $19 to...

The Comparative statements of cash flows for Executive style corporation, a manufacturer of high-quality suits for men, appear on the next page. To expand its markets and familiarity with its brand,...

Total fixed costs can change if volume is outside the relevant range. True or false

The type of internationalization of Hershey Company likely to be applied (incremental or born global). Includes the emerging market country location selection based on the SWOT analysis.

Auto pistons at JE Piston's plant in Melbourne are produced in a foreign process, and the diameter is a critical factor that must be controlled. From a sample size of 1000 pistons produced each day,...

The ledger of Bama Inc. had the following account balances on December 31, 2020. Accounts payable $16,600 Office equipment $4,750 Accounts receivable 4,750 Raw materials inventory 4,800 Accrued...

Imagine you are advocating that your organization develop a new onboarding program. Using the details of the program below, calculate the dollar amount of the orientation program's benefits, its...

On fixed price contracts the WBS helps to ensure that the full scope of work is included True False

Which phase in the SDLC is the most important?

Are some nonfunctional requirements more important than others in influencing the architecture design and hardware/software specification?

Why should you consider the storage formats that already exist in an organization when deciding on a storage format for a new system?

Advertising transforms a product into a mirror of its consumer. Explain this in terms of branding.

Brands enable consumers to communicate something about themselves. Explain how this might work.

If a corporation has both consumer and industrial products, to what extent can their marketing communication activities be consolidated? Illustrate with examples.