Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Assignment 11 1) Open SQL Developer then load the Schema_creation.sql and table population.sql scripts to create and populate the tables discussed in assignment I. Open

image text in transcribed

Assignment 11 1) Open SQL Developer then load the Schema_creation.sql and table population.sql scripts to create and populate the tables discussed in assignment I. Open a new SQL worksheet then write the PL/SQL code that creates the following objects. 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 (productNO). [1.5] 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. [1.5] 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 Bl and from C2 to C1 when a customer's balance status drops below a certain threshold (-10000).[2] 5) Save the script as assignment2_yourID then submit this file via Blackboard on or before

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Learning PostgreSQL

Authors: Salahaldin Juba, Achim Vannahme, Andrey Volkov

1st Edition

178398919X, 9781783989195

More Books

Students also viewed these Databases questions

Question

Question What is a secular trust?

Answered: 1 week ago