answer 5 and it's part

5) Create a new folder named assignmentl_yourID. Put in this folder all the scripts created in the above questions. Compress the folder then submit it via Blackboard on or before Introduction to databases FALL 20 Assignment II 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 following objects, 2) Create in PL/SQL a stored procedure called 'Del Details' to delete the record of ordered Product 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 BI and from C2 to CI when a customer's balance status drops below a certain threshold (-10000).[2] Description of the schema The following database is used by a building materials company to edit invoices for its customers and to manage its inventory The schema of this database contains the following tables: The customer table is used to record the properties of the company's customers: name, address, etc. The product table is used to record the properties concerning the building materials available for sale: their description, the unit price, the quantity in stock. The order table is used to record the properties concerning an order: its number, the date of the order and the customer identifier. The ordered Product table is used to record the "lines" of orders along with the products: the order identifier (orderNO), the product identifier (productNO) and the quantity ordered. Customer (customer NO, customerName, address, city, category, custBalance) Product (productNO, label, price, QStock) customer Order (orderNo. order Date, #customerNO) ordered Product (#order NO. #productNO, orderQuantity) Note: Primary keys are underlined and foreign key are marked with #. Use SQL Developer to answer the questions given below