Write a script that creates and calls a stored function named item_total that calculates the total amount of an item in the Order_Items table (discount price multiplied by quantity). To do that, this function should accept one parameter for the item ID, it should use the discount_price function that you created in exercise 2, and it should return the value of the total for that item.

Write a script that creates and calls a stored function named item_total that calculates the total amount of an item in the Order_Items table (discount price multiplied by quantity). To do that, this function should accept one parameter for the item ID, it should use the discount_price function that you created in exercise 2, and it should return the value of the total for that item.

Np Ms Office 365/Excel 2016 I Ntermed

1st Edition

ISBN:9781337508841

Author:Carey

Publisher:Carey

Chapter8: Working With Advanced Functions

Section: Chapter Questions

Problem 4.3CP

See similar textbooks

Similar questions

Create a function in your own database that takes two parameters: A year parameter A month parameter The function then calculates and returns the total sales of the requested period for each territory. Include the territory id, territory name, and total sales dollar amount in the returned data. Format the total sales as an integer. Hints: a) Use the TotalDue column of the Sales.SalesOrderHeader table in an AdventureWorks database for calculating the total sale. b) The year and month parameters should have the SMALLINT data type.
A computer store uses a database to track inventory. The database has a table named Inventory , with the following columns: ProductID INTEGER PRIMARY KEY NOT NULL ProductName TEXT QtyOnHand INTEGER Cost REAL Also assume that the cur variable references a Cursor object for the database. Write Python code that uses the Cursor object to execute an SQL statement that deletes the row in the Inventory table in which ProductID is equal to 12.
An organization has a file named “staff.txt” that has 10 records of staffs having their id, name and salary. Using the concept of structure, you are required to write a program to ask the details of three more staffs and add them in the file. Also, finally you need to display all the records and the total salary paid by the organization.
Input and run the VALID_DEPTID function to see how it works. CREATE OR REPLACE FUNCTION valid_deptID ( p_deptid IN departments. department_id%TYPE) RETURN BOOLEAN IS v_dummy PLS_INTEGER; BEGIN select 1 into v_dummy from departments where department_id = p_deptid; return TRUE; EXCEPTION WHEN NO_DATA_FOUND THEN RETURN FALSE; END valid_deptID;| Describe what the VALID_DEPTID function does.
The above screen is used to browse the products table it uses the ProductDAO.java file, it calls the getProductByCriteria() function which should accept a parameter, this parameter should be the criteria that would be built from the two combo boxes and the text box, and queries the products table.The getProductByCriteria() function should return a list of Product objects that matches the criteria specified. Modify the function so that it accepts a string paramater consisting of the fields from the combo boxes and a price number from the text box separated by commas and use this string to modify the query in the function to return the desired result set. public List<Product> getProductByCriteria() //MAKE MODIFICATIONS TO THIS FUNCTION SO IT CAN TAKE PARAMETER(S) { if (openConnection()) { try{ List<Product> items = new ArrayList <> (); Product temp = null; String…
using python Create four variables for the database class: str_databasename, int_databaseid, lst_tablenames and int_count. str_databasename will store the name of the database, int_databaseid will store the identification number of the database and each identifier number is a unique number. lst_tablenames will store the list of tables for one particular database object. Int_count will store the number of tables for this database object.
This application manages a parking space for a configurable maximum number of vehicles. The designed application must handle the following functions: ● Each garage slot has a width and depth that describes the slot dimensions.● The garage consists of a configurable maximum number of slots with different dimensions. ● Each vehicle shall be identified by a model name, unique identification number, Model year and vehicle dimensions (width and length).● Park-in function that marks the arrival time of a vehicle if there is an available slot that matches vehicle dimensions.● The slot selection for vehicle park-in could be done using multiple algorithms:○ First Fit selection where the first slot with big enough dimension to host the vehicle will be selected○ Best Fit selection where the slot with the best dimension match should be used where the wasting area of the slot is minimized. ● Slot selection algorithms could be extended in the future version of the application.● Park-out function…
Create a user-defined function called calculate_gains(), which receives the amount desired to be invested. Outside this function, create a global variable, multiplier_amount that would be accessible at any point in your code to store the "multiplier amount", which will be the amount that would trigger the increase on the gain margin in case the invested amount is greater than this value. In our case, this amount is set to 1 million. Inside your function, create a variable to store the gain margin, which is 0.1% by default. Also create variables for total_gains and total_amount, setting default values to 0. After these declarations, the first thing to check is whether the amount invested is greater than 1000 (one thousand), which is the minimum application value to start using the app. Next, check if the amount is greater than the multiplier value (1 million). If it is greater, then update the gain margin variable with the new gain margin and add the estimated amount to the original…
Look at the code below and use the following comments to incdicate the scope of the static variables or functions. Place the comment below the relevant line. Module scope Class scope Function scope The code runs. Use onlinegdb.com to see it run. Module scope means global but only known in this source file. Class scope means global but only known by the class. Function scope means global but only known in the function. Hide Comments 1 #include 2 static const int MAX_SIZE=10; 5 // Return the max value 6 static double max(double d1) 7 { static double lastMax = 0; lastMax = (di > lastMax) ? di : lastMax; return lastMax; 8 10 11 } 12 13 // singleton class only one instance allowed 14 class singleton 15 { public: static Singleton& getsingleton() { return theone; } // Returns the Singleton 16 17 18 19 20 friend std::ostream& operator<< (std::ostream& o, const Singleton& s); private: Singleton() { }; // Prevents more instances 21 22 23 24 25 static Singleton theone; 26 }; 27 Singleton…
Javascript Create a function named "getUser". This function needs to accept a "userID" parameter. Use Fetch with Async/Await to request the data for the requested user. The function should return JSON data.
In order for a player to navigate your game, you will need to develop a function or functions using Python script. Your function or functions should do the following: Show the player the different commands they can enter (such as “go North”, “go West”, and “get [item Name]”). Show the player’s status by identifying the room they are currently in, showing a list of their inventory of items, and displaying the item in their current room. You could make these separate functions or part of a single function, depending on how you prefer to organize your code. Sample function showing the goal of the game and move commands def show_instructions(): #print a main menu and the commands print("Dragon Text Adventure Game") print("Collect 6 items to win the game, or be eaten by the dragon.") print("Move commands: go South, go North, go East, go West") print("Add to Inventory: get 'item name'") The blue image is an example of how the code should look. The map image is the map your code should…
In order for a player to navigate your game, you will need to develop a function or functions using Python script. Your function or functions should do the following: Show the player the different commands they can enter (such as “go North”, “go West”, and “get [item Name]”). Show the player’s status by identifying the room they are currently in, showing a list of their inventory of items, and displaying the item in their current room. You could make these separate functions or part of a single function, depending on how you prefer to organize your code.