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

The goal is to rewrite the function, below, such that passes in a different list of parameters, particularly eliminating the need to pass low and high for each recursive call to binary_search. defbinary_search(nums,low,high,item): mid=(low+high)//2iflow>high:returnFalse #The item doesn't exist in the list!elifnums[mid]==item:returnTrue# The item exists in the list!elifitem<nums[mid]:returnbinary_search(nums,low,mid-1,item)else:returnbinary_search(nums,mid+1,high,item) The new function should be prototyped below. The number of changes between the given version, and the one requested is not significant. defbinary_search(nums,item):pass# Remove this and fill in with your code Tip: If you consider that high and low are used to create a smaller version of our problem to be processed recursively, the version requested will do the same thing, just through a different, more Pythonic technique.
"Write a" function call to realloc() that is equivalent to malloc(sizeof(char*))
Give Description of GetConsoleCP function.
Compile a list of all of the times when invoking inline functions doesn't work as expected.
WRITE THE CODE OF MYSQL IN PYTHON AND DO THIS FUNCTION PLEASE IN 20 MINUTES JUST THE LAST QUESTION (6) Define a function that reports the total price of the items with respect to their type. For example, the total price of sold paintings is 420000.
Give an example of how calling an inline function is different from calling a normal function in the background, and explain how the difference came to be. Also, give a specific example of how the change came about.
‘Write a function has_unique_values() that takes a dict as a parameter and returns True if the keys have unique values (that is not two keys have the samevalues) Write several assertion to test this function.
Write a Matlab function called that will: read in the spreadsheet file, accept two textual/string arguments: first metric abbreviation/acronym (for example GP) from the list above, Second metric abbreviation/acronym (for example 3P%) from the list above, finds the player (A) who has the highest/maximum value of the FIRST METRIC (if there is more than one with that value, pick the first one - lowest row number) and stores his name and corresponding FIRST METRIC value, finds the player (B) who has the lowest/minimum value of the FIRST METRIC (if there is more than one with that value, pick the first one - lowest row number) and stores his name and corresponding FIRST METRIC value, computes FIRST METRIC average for all players, finds SECOND METRIC value for both players found above, computes SECOND METRIC average for all players.
Language: C Write the function convolve that will calculate the confolution of two functions f, g on [0, t] interval. The convolution is defined as (f ∗ g)(t) = Z t 0 f(τ )g(t − τ ) dτ for f, g : [0, ∞) → R. The argument function f and g should be passed by pointers. The integral should be approximated by the Riemman sum, i.e., Z b a f(x) dx = Xn i=1 f(xi) ∆x, where ∆x = b−a n and xi = a + i ∆x. Define the functions func1, func2 and func3, that return sin(x), cos(x) and x 3 respectively. Use these functions to calculate the convolution of f = sin(x), g = sin(x) f = sin(x), g = cos(x) f = sin(x), g = x 3 for t = 2π and n = 1000.
Consider the following recursive function: void recurse(int num) { if (num == 0) cout << “ Zero” << endl; else { cout << " " << num << " " << endl; recurse(num + 1) } } Is recurse (-2) a valid call? If a valid call, what is the output of the entire function execution? If not a valid call, explain why it is not a valid call.
Create the function that takes a list of dictionaries and returns the sum of people's budgets. Examplesget_budgets([ { "name": "John", "age": 21, "budget": 23000 }, { "name": "Steve", "age": 32, "budget": 40000 }, { "name": "Martin", "age": 16, "budget": 2700 }]) ➞ 65700 get_budgets([ { "name": "John", "age": 21, "budget": 29000 }, { "name": "Steve", "age": 32, "budget": 32000 }, { "name": "Martin", "age": 16, "budget": 1600 }]) ➞ 62600
Can commonly used operators, such the arithmetic and stream operators, be accessed quickly thanks to the usage of enumeration types? Is it conceivable to get an acceptable result by, say, exceeding the capacity of these operators? What are the pluses and minuses of this method?