Inventory Management System

^{Now that I look back to the codebase after a few years being a Software Engineer, it feels like a nightmare to me! I broke every rule SOLID suggests like a king! Thanks for understanding! LOL}

Multi-user, RDBMS system for inventory management
Worked on this project for my RDBMS course.

Tech Stack

Frontend:

• JavaFX (for GUI development)

Backend:

• Java (JDK 8, for application logic)
• MySQL (as the relational database)

Environment

• IntelliJ IDEA
• MySQL Workbench 8 on Legacy Mode
• JDK 8
• Gluon Scene Builder

Installation

1. Make sure MySQL is installed properly and running at port 3306 with username 'root' and password 'root'
2. git clone https://github.com/manishkmr49/Inventory-System.git
3. Open MySQL Workbench and login to your root account
4. From File menu click Open SQL Script
5. Navigate to: ../InventorySystem/sql and select inventory.sql file
6. From Query menu select Execute All and wait till it finishes
7. Navigate to InventorySystem/jar/
8. Open CMD/Terminal and type: java -jar InventorySystem.jar
9. You're all set!

Features

• Dashboard
• Multi-level Access Privilege
• Auto Due Update
• Elegant UI and Robust Visualization
• Relational Database Oriented System
• Multi-threaded

CAUTION

• MySQL Workbench should be installed in port 3306 with username 'root' and password '12345'
• JDK 1.8 should be installed and available to the system path

Project Skeleton

UML Class Diagram:

Database Schema:

Prototypes:

For any query contact through: https://github.com/manishkmr49