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 #000000770, $74.55. Supplier with dearest cost: 2308, 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.

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 #000000770, $74.55. Supplier with dearest cost: 2308, 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.

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

1. in C: write program with struct student, that has name and age. Declare a pointer to struct student *ptr, but don't assign a value to it. Then, print ptr->age. 2. What GDB commands would you use to identify the error that occurs?
Please elaborate on the benefits of using high-order, pure functions.
Design a data structure to store the class score and exam score of students (using their index numbers) in each course. The students read only 3 courses; English (ENGL 101), Maths (MATH 101) and Science (SCI 101). [Hint: Use a combination of dictionaries and, either list or tuples—whichever one you decide].
Can you use Python programming language to to this question? Thanks
How does the Use of LOOKUP function to get the directory of a store, be useful and applicable in business and other transactions?
Write a php function (in the space below or attach a file) that returns an array of total sales values for each cookie type in each store.....notice this is a query from a previous section. You can call that query $sqlTotalSales . The function will take three parameters: $numUnits and $priceUnit are strings representing the attributes/columns in the table and $tableName is the name of the table....we could use "Units_Sold" and "Price/unit" for a particular table but what if you want to reuse this function for another dataset? Hence the variables.
Explain how invoking inline functions differs from calling standard functions and provide an example. Also, demonstrate how the change was made.
1. Give an example to show how to convert Dict type to DataFrame? 2. Give an example to show how to convert Series type to DataFrame?
Program solution in language MATLAB And send the solution as M-file