SOFTWARE
Library Management System
Comprehensive library and bookshop management application with dual modules for administrators and customers, built using C# and database technologies.
Project Overview
Developed a comprehensive "Library Management System" during my undergraduate C# course using C#, MySQL, MSSQL, and Windows Forms. The project focused on building a fully functional desktop-based application integrating database management and user interface design to streamline library and bookshop operations.
Objectives
- Design and implement a database-driven library management system.
- Integrate front-end Windows Forms with relational databases.
- Develop role-based modules for administrators and customers.
- Enhance system efficiency, automation, and transaction tracking.
My Responsibilities
- Designed and developed the application using C# with Windows Forms for the front-end.
- Integrated MySQL and MSSQL databases for data storage and management.
- Implemented 15+ core features to enhance overall system functionality.
- Developed role-based modules including Admin and Customer interfaces.
- Ensured smooth database connectivity, CRUD operations, and transaction management.
Key Insights
- Admin Module: Managed student records, book inventory, loan lists, email notifications, transaction history tracking, and invoice generation.
- Customer Module: Enabled book search (by title, author, genre), streamlined purchasing process, account deposits, order confirmation with billing, transaction history viewing, and invoice printing.
- Successfully implemented end-to-end database operations with secure transaction handling.
- Strengthened understanding of desktop application architecture and relational database integration.
Impact
- Delivered a fully functional library and bookshop management system improving operational efficiency.
- Enhanced practical expertise in C#, database integration, and Windows Forms development.
- Built strong foundational skills in full-stack desktop application development.
