Client
Academic (Chitkara University)
Timeframe
January 2020 – June 2020
Services
Java, JDBC, MySQL, Object-Oriented Programming, SQL Connectors
Project Overview
Engineered modular Java components for books, users, and transactions. Developed JDBC-based SQL connectors for real-time library functions such as checkouts, overdue tracking, and student registration.
Challenge
The primary challenge was building a scalable, low-maintenance architecture for a library system from scratch. Integrating real-time SQL operations with JDBC while maintaining separation of logic, minimizing code duplication, and ensuring data integrity across modules required meticulous structuring. Limited team size and academic deadlines added constraints to delivery.
Results
Successfully implemented a modular architecture that reduced logic coupling by 30%, allowing seamless future enhancements. Delivered a fully operational application with high data accuracy and responsive performance under multi-user load. Improved maintainability and onboarding efficiency for team members through well-documented code and interface structure.