Purdue CS 348 Information Systems - Project 2: PL/SQL
@Harris Christiansen (christih@purdue.edu) HarrisChristiansen.com
April 2018
Description
- Perform some common database operations using PL/SQL
Problems
- Pro_order_status: Generate the report based on state of the orders for last month and 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).
- Pro_prod_report: Generate a report based on inventory of the products into 3 categories
- Pro_age_categ: Find the top category ordered by customers of different age groups.
- Pro_category_info: Generate a report to display the details about each category. These details include the number of units of that category ordered, the average unit price of the products in that category, the average discounted amounts given.
- Pro_search_customer: Given a customerid, find the details about that customer.
- Pro_search_supplier: Given a supplierid, find the details about that supplier and the products provided by the supplier.