b) Implement a stored PL/SQL function that finds a supplier who supplies the cheapest (lowest supply cost) or the dearest (highest supply cost) for a part specified by a user. The function should obtain the part key as its formal parameter, and it should return a string of values consisting of the supplier key, supplier name, and the cost (cheapest and dearest). Example of the string output are as follow: Supplier with cheapest cost: 1344, Supplier #000001344, $172.09. Supplier with dearest cost: 2882, Supplier #000002882, $791.07. Supplier with cheapest cost: 770, Supplier with dearest cost: 2308, Supplier#000000770, $74.55. Supplier #000002308, $826.35. Next use the function to list the string output as specified above for part numbers 3753, 43064, 57574 and 60000 using a select statement. Deliverables Submit your spooled file solution2b.lst (or solution2b.pdf) that contains your SQL script and the output from the execution of the script. The report must have no errors related to the implementation of your task and it must list all PL/SQL and SQL statements processed.

b) Implement a stored PL/SQL function that finds a supplier who supplies the cheapest (lowest supply cost) or the dearest (highest supply cost) for a part specified by a user. The function should obtain the part key as its formal parameter, and it should return a string of values consisting of the supplier key, supplier name, and the cost (cheapest and dearest). Example of the string output are as follow: Supplier with cheapest cost: 1344, Supplier #000001344, $172.09. Supplier with dearest cost: 2882, Supplier #000002882, $791.07. Supplier with cheapest cost: 770, Supplier with dearest cost: 2308, Supplier#000000770, $74.55. Supplier #000002308, $826.35. Next use the function to list the string output as specified above for part numbers 3753, 43064, 57574 and 60000 using a select statement. Deliverables Submit your spooled file solution2b.lst (or solution2b.pdf) that contains your SQL script and the output from the execution of the script. The report must have no errors related to the implementation of your task and it must list all PL/SQL and SQL statements processed.

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Similar questions

Is computer gaming good or harmful to humans in the long run? What makes you believe that?
Which inventor constructed the first digital computer?
Is it true that Grace Hopper was the first woman to use a computer?
How well-versed are you in the modern applications of computers?
Amateur radio is an example of simplex communication Select one: O True O False
Discuss briefly about the concept of Error Guessing.
Is it true that Steve Jobs invented the first computer, or did someone else claim credit for the achievement?
What is the name of and origin of Alan Turnig?
Chose the correct answer
What are the top six factors that contribute to the widespread prevalence of computer errors in today's world?
What ideas did pioneering computer scientist Ada Lovelace develop?
Is it possible that Steve Jobs invented the first computer?