Improving Retail Management with Java and SQL: A Smarter Solution to Inventory and Sales Tracking

Presenter: Maria Delia

Group Members: Aiden Scott Bukoski

Faculty Sponsor: Nada Al Sallami

School: Worcester State University

Research Area: Computer Science

Session: Poster Session 2, 11:30 AM - 12:15 PM, 163, C17

ABSTRACT

Running a retail company efficiently requires a well-structured database and a friendly interface. This project enhances a retail database system by merging Java with SQL, making it more efficient and user-friendly. The system comes with a graphical interface based on Java that allows users to manage products, track sales, and update customer records without having to directly interact with SQL queries.

Inventory management is an integral part of this project, enabling businesses to track inventory levels in real time. Inventory is automatically updated when sales are made, and users receive alerts when the products are running low, enhancing inventory control. There is also a sales reporting feature, which provides useful insights through analysis of sales trends, top-selling products, and revenue monitoring. This helps businesses make informed decisions to maximize profitability.

To enhance customer engagement, the system 
has a rewards program that rewards loyal customers with points for every transaction. The points are stored in the database and can be redeemed for offers or promotions.

With the integration of SQL and Java, this project improves retail management with efficiency, reduced manual work, and improved decision-making. The synergy that arises with the adoption of real-time inventory tracking, sales analysis, and customer loyalty makes for an improved and modern retail management system.

RELATED ABSTRACTS