Create in PL/SQL a stored Function

Assignment Help Database Management System

Reference no: EM133117755

Assignment - Induction to databases

Question 1) Open SQL Developer then load the Schema_creation.sql and table_population.sql scripts to create and populate the tables discussed in assignment 1. Open a new SQL worksheet then write the PL/SQL code that creates the follawing objects.

Question 2) Create in PL/SQL a stored procedure called 'Del_Details' to delete the record of orderedProduct table for which it receives as input the order number (orderNO) and the product number (produetNO).

Question 3) Create in PL/SQL a stored Function called 'productPerOrder' to return the number of products placed for any order its number is given as input.

Question 4) Write a Trigger called 'changeCustomer_Category'. This trigger should be invoked before any update of customer balance in customer table. Its job is to modify the category of a customer from B2 to B1 and from C2 to C1 when a customer's balance status drops below a certain threshold (-10000).[2]

Question 5) Save the script as assigrunent2_yourID then submit this file.

Reference no: EM133117755

Questions Cloud

What is the total present value : What is the total present value of $30 received at the end id year one, $500 received in year four, and $200 received in year sixth if the discount rate is 7%

Calculate the issue price of the bonds and record issuance : On January 1, 2017, Whitefeather Industries issued 1,100, $1,000 face value bonds. Calculate the issue price of the bonds and record issuance

Explain standards of privacy-security : Explain the standards of privacy, security, and confidentiality involved. Explain what laws, policies, and regulations were violated.

What was the stock return for the missing year : The average return of the stock over this period was 10.3 percent. What was the stock return for the missing year

Create in PL/SQL a stored Function : Create in PL/SQL a stored Function called 'productPerOrder' to return the number of products placed for any order its number is given as input

Prepare classified balance sheet using the balances listed : The note is payable over 3 years and $8,000 will be paid by September 30, 2019. Prepare classified balance sheet using the balances listed

Determine the break-even point in units and dollars : Equation method - Zachary Corporation produces products that it sells for $20 each. Determine the break-even point in units and dollars

Calculate the after tax of debt : Question - A firm has outstanding 11% coupon bonds that have a yield to maturity of 8%. Calculate the after tax of debt

Ethical manner in regards to their stakeholders : Explain what ethics is all about and why managers and business entities should act in an ethical manner in regards to their stakeholders.

User Account

All Pages