Multi-user, RDBMS system for inventory management
Worked on this project for my RDBMS course in DIU
Tech Stack
JavaFX, MySQL
Environment
- Intellij Idea
- MySQL Workbench 8 on Legacy Mode
- JDK 8
- Gluon Scene Builder
- Make sure MySQL is installed properly and running at port 3306 with username 'root' and password 'root'
git clone https://github.com/afifaniks/InventorySystem.git
- Open MySQL Workbench and login to your root account
- From File menu click Open SQL Script
- Navigate to:
../InventorySystem/sql
and selectinventory.sql
file - From Query menu select Execute All and wait till it finishes
- Navigate to
InventorySystem/jar/
- Open CMD/Terminal and type:
java -jar InventorySystem.jar
- You're all set!
Watch this video for more: https://youtu.be/Q35IDSXXz3Y
- Dashboard
- Multi-level Access Privilege
- Auto Due Update
- Elegant UI and Robust Visualization
- Relational Database Oriented System
- Multi-threaded
- MySQL Workbench should be installed in port 3306 with username 'root' and password 'root'
- JDK 8 should be installed and available to system path
UML Class Diagram:
Databse Schema:
Prototypes:
For any query contact through: https://afifaniks.me