DMDD_DBDEV_Final_Project

Steps to execute the scripts

• Login to your ADMIN user

• Run KITKY_ADMIN_SCRIPT.sql from your Admin user to create user: KITKY_ADMIN

• Login as KITKY_ADMIN with right credentials

• Run the following scripts in the below order under KITKY_ADMIN user

  • DDL.sql
  • CALCULATE_DRIVER_SALARY.sql, CALCULATE_ORDER_AMOUNT.sql under KITKY_ADMIN --> Functions
  • SAVE_HISTORY_LOG under KITKY_ADMIN --> Triggers
  • ALL_STORED_PROCEDURES.sql under KITKY_ADMIN
  • VIEWS_SCRIPT.sql under KITKY_ADMIN
  • BUSINESS_REPORTS.sql under KITKY_ADMIN --> Business Reports
  • USER_CREATION_PACKAGE.sql under KITKY_ADMIN
  • USER_MANAGER_DML.sql under USER_MANAGER
  • DELIVERY_AGENT_MANAGER_DML.sql under DELIVERY_AGENT_MANAGER
  • ORDER_MANAGER_DML.sql under ORDER_MANAGER
  • BUSINESS_ANALYST_VIEWS.sql under BUSINESS_ANALYST (To view the views for analysis)

• Login as different users to execute the respective procedures to insert data and access views.