Any Late Day will be penalized by 10% of the grade until a maximum of 5 days, after which the project will not be accepted.Overview: In this project, you will perform some common database operations. The schema is slightly modified from the one used in Project 1, so make sure to use the scripts provided with this package. You MUST use PL/SQL for this project. You should use your Purdue Oracle account to create and test the queries. Submit your answers via Blackboard.Note: The numbers should be accurate to 2 decimal places. (For instance, 90, 90.5 and 90.50 are all acceptable. But 90.555 is unacceptable.)Customer(CustomerId, FirstName, LastName, Address, PhoneNo, Age) Supplier(SupplierId, FirstName, LastName, Address, PhoneNo) Product(ProductId, ProductName, Category, SupplierId, ProductDescription) Inventory(ProductId, TotalStock, LastUpdatedOn)Orders(OrderId, CustomerId, OrderDate, Status) OrderItems(OrderId, ProductId, Quantity, UnitPrice, Discount)Step 1: Drop the tables if existing:SQL @droptales.sqlStep 2 : Then create the new tables using script tables.sql SQL @tables.sqlStep 3 : Then, add the data to the database using Script data.sql. SQL @data.sqlStep 4: PL/SQL Procedures: In this part, you are going to use PL/SQL(Oracle’s procedural extension to SQL) to write procedures to process data.Create a file named procedures.sql. The first line of this file should be :set serveroutput on size 32000Your file should contain code to create and run six procedures: Your file should look something like this: /*createtheprocedure*/createorreplaceprocedurePro_order_statusas/*declarations*/begin/*code*/end;/*actuallyruntheprocedure*/beginPro_order_status;end;createorreplaceprocedurePro_prod_reportasbegin/*code*/end;beginPro_prod_report;end;/Procedures1.Pro_order_status : Generate the report based on state of the orders for last monthand last year. Find the total number of orders in delayed and shipped states over last month (last 30 days) and last year(last 12 months). These dates are matched with orderdate in orders table. The output should be as follows:DURATION DELAYED_ORDERS SHIPPED_ORDERS

所有的编程代写范围：essayghost为美国、加拿大、英国、澳洲的留学生提供C语言代写、代写C语言、C语言代做、代做C语言、数据库代写、代写数据库、数据库代做、代做数据库、Web作业代写、代写Web作业、Web作业代做、代做Web作业、Java代写、代写Java、Java代做、代做Java、Python代写、代写Python、Python代做、代做Python、C/C++代写、代写C/C++、C/C++代做、代做C/C++、数据结构代写、代写数据结构、数据结构代做、代做数据结构等留学生编程作业代写服务。