/Kitky

Database model for Pickup and Drop Service

Primary LanguagePLSQL

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.