Write a script that creates and calls a function named fnStudentUnits that calculates the total course units of a student in the StudentCourses table. To do that, this function should accept one parameter for the student ID, and it should return the sum of the course units for the student. The SELECT statement that calls the function should return the StudentID from the StudentCourses table, the CourseNumber and CourseUnits from the Courses table, and the value return by the fnStudentUnits function for that student.

Write a script that creates and calls a function named fnStudentUnits that calculates the total course units of a student in the StudentCourses table. To do that, this function should accept one parameter for the student ID, and it should return the sum of the course units for the student. The SELECT statement that calls the function should return the StudentID from the StudentCourses table, the CourseNumber and CourseUnits from the Courses table, and the value return by the fnStudentUnits function for that student.

Programming with Microsoft Visual Basic 2017

8th Edition

ISBN:9781337102124

Author:Diane Zak

Publisher:Diane Zak

Chapter6: Sub And Function Procedures

Section: Chapter Questions

Problem 5E

See similar textbooks

Similar questions

Write a script that creates and calls a function named fnTuition that calculates the total tuition for a student. To do that, this function should accept one parameter for the student ID, it should use the fnStudentUnits function that you created in question 1, and it should return the value of the tuition for that student depending on whether the student is fulltime (more than nine units) or parttime (nine or fewer units). (Hint: Use a cross join to work with data in the Students and Tuition tables.) The SELECT statement that calls the function should return the StudentID from the Students table, the value returned by the fnStudentUnits function for that student, and the value returned by the fnTuition function for that student. Return only rows for students taking one or more units.
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.
Below is the code for a procedure that will accept a Customer ID as an input parameter and display the Customer ID, Customer Surname and Customer Address. Review the code, then answer the questions that follow. create or replace procedure sp_customer_details (c_id IN CUSTOMER.cust_id%TYPE,customer_details out VARCHAR2)ISBEGINSELECT 'CUSTOMER ID:' || c.cust_id || ', Surname:'|| c.cust_sname || ',ADDRESS:' ||c.cust_addressinto customer_detailsfrom CUSTOMER cwhere c.cust_id = c_id;END; Q.1 Briefly discuss the advantages of using the %TYPE attribute in the code. Q.2 Create the code to execute the procedure with exception handling if no customer data is found. Use customer ID C115 in your code.
Write a function called ValidSupplier(SupplierID) that takes as its only input a SupplierID. If the supplier exists in the database your function should return True otherwise it should return False For example: Test Result print(ValidSupplier(13)) True
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.
Which of the following is false? a. The position of the arguments listed in the Call statement should agree with the position of the parameters listed in the receiving procedure’s parameterList. b. The data type of each argument in the Call statement should match the data type of its corresponding parameter in the receiving procedure’s parameterList.c. The name of each argument in the Call statement should be identical to the name of its corresponding parameter in the receiving procedure’s parameterList. d. When you pass information to a procedure by value, the procedure stores the value of each item it receives in a separate memory location.
Review the DonationTimeLeft function as a group. What value do you think the function will return if it is given 1300 as the argument? Write your answer below. What information do you think will be stored in time_left after calling DonationTimeLeft(1300)? Which lines of code do you think will call the AnnounceDonation function? Write the line numbers below.
Write a function called ValidSupplier(SupplierID) that takes as its only input a SupplierID. If the supplier exists in the database your function should return True otherwise it should return False
Write a script that creates and calls a stored function named TotalOrders that calculates the total number of orders in the orders table. To do that, this function should not accept any parameter, and it should return the total number of orders in the orders table. Call the function from an anonymous block. Add SQL statement(s) that will display current date and your name and student ID in the format specified below. Your anonymous block must include exception handling.
Call the function from a PROCEDURE. Name the procedure findDiscPrice. Allow the user to pass a parameter customer ID (customer_id) to the procedure. Calculate and display the new item price for the customer similar to the example below. Assume we will call the procedure from the following Anonymous Block begin findDiscPrice (1); findDiscPrice (2); findDiscPrice (3); end; Expected output: Customer Doctor Who new item price is 990 Customer Harry Potter new item price is 40 Customer Captain Awesome new item price is 2400
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…
Please execute the following statements. Write down the return value for each statement and explain what each of the functions cons, append, and list ; Scheme interprets everything to the right of a semicolon (;) as a comment. You should always start your file with comment lines that include your name, W#, and assignment title (cons 3 '(1 2)) (cons '(1 5) '(2 3)) (list 3 '(1 2)) (list '(1 5) '(2 3)) (append '(1) '(2 3)) (append '(1 5) '(2 3)) (cons 'x '(1 2)) (list 1 2 3 '(4 5)) (cons '1 '2 '3 '(4 5))