Inventory Inventory and Employee Management System

Welcome to my Warehouse Inventory Management project, where I delve into the application of a Relational Database Management System (RDBMS) to streamline and optimize the processes associated with inventory control. In this exploration, the focus is on leveraging the structured and organized nature of an RDBMS to enhance the overall efficiency of warehouse operations. The project aims to provide a robust solution for managing stock levels, reducing errors, and improving decision-making processes. By integrating the power of an RDBMS, this initiative seeks to offer a scalable and reliable framework that not only ensures real-time visibility into inventory but also contributes to the seamless orchestration of various warehouse activities. Join me on this journey to uncover the potential of database technology in revolutionizing warehouse inventory management.

*All files are required to be in the same directory in order for complete execution of the project*

Specifications of Project

• HTML and CSS for front End
• PHP 8.3.4 for Backend connectivity
• Database using MySQL Workbench
• I have used XAMPP v3.3.0 for hosting the server

Entity Relation Diagram for the project

Relational Model

---

SQL END

• You will have to run the following commands in MySQL to create the database in use:

• For complete utilization of functionalities, the following Triggers would be required:

  • employee_deleted_trigger OR manager_deleted_trigger

    • This triggered is used when an employee quits or is fired.
    • This trigger takes the info of the employee that was fired, and stores it an “Ex_employee” table for any further use, when the employee data is deleted from the Manager or Employee table.
    • To achieve this, we have to make 2 different triggers for each, Manager and Employee table, for when data is removed from them, this trigger also inserts the designation and date of removal of the employee to keep a well-maintained record.

  • inventory_deleted_trigger

    • When an inventory item is deleted from the inventory database, this means the item was completely sold out.
    • Hence, this trigger stores the info of the item which was sold for calculation the total sale of goods from a warehouse in the end.