Library Management System

A C# Windows Forms library and bookshop application integrating relational databases and 15+ admin/customer features.

PROJECT GALLERY

Actual screenshots from the original public project.

01 / 01

Library Management System — original Windows Forms application

Open original image

PROJECT TYPEAcademic / Software & Data

MY ROLEAcademic desktop application development

TOOLS & METHODSC# · Windows Forms · MySQL

PROJECT OVERVIEW

The story behind the work

For an undergraduate C# course, I developed a Windows Forms desktop application for library and bookshop operations. The work combined interface design and relational databases, with separate workflows for administrators managing the system and customers searching or purchasing books.

THE CHALLENGE

Manage book inventory, loans, orders and related records through a database-backed desktop interface.

GOALS & SCOPE

What I set out to do

Create a database-backed desktop application with administrator and customer modules.
Manage inventory, borrowing, purchasing, account records and transaction history.
Implement connected user interfaces with CRUD operations and persistent records.
Cover common library and bookshop workflows in a consistent system.

PROCESS & IMPLEMENTATION

From raw data to a useful result

Developed C# Windows Forms interfaces integrated with MySQL and SQL Server, supporting role-based CRUD and transactions.

Designed the application screens and distinct role-based navigation in C# Windows Forms.
Connected user-interface actions to MySQL and Microsoft SQL Server relational storage.
Implemented more than 15 core functions supporting book records, transactions and account activity.
Built administrator flows for student records, stock, loan lists, notifications, history and invoices.
Added customer-facing book search by title, author or genre, purchase and deposit actions, order confirmation and receipt or invoice output.

MY ROLE & RESPONSIBILITIES

What I contributed

Academic desktop application development, database integration and implementation of 15+ documented functions.

Developed the Windows Forms application interface and its core database-backed workflows.
Implemented and connected the separate administrator and customer modules.
Practiced relational data operations, CRUD handling and transaction flows through a real desktop UI.

RESULTS & FINDINGS

What the project delivered

The delivered academic desktop project covered more than 15 documented functions.
Administrative screens supported inventory and loans alongside account records and financial history.
Customer screens supported search, ordering, deposits and billing workflows.
The project is evidence of application and database integration, rather than a claim of deployment to a public library.

OUTCOME & CONTEXT

The result was an end-to-end desktop demonstration of combining C#, Windows Forms and relational databases around practical library workflows, providing hands-on experience with application design, persistence and transactions.

REFLECTION

Challenges & lessons

Keeping records and transactions consistent across application modules

Database design and interface workflow must be developed together.