Skip to content
Back to projects
Web
2022
Completed

Library Management System

Web application handling the full circulation lifecycle: catalogue, loans, returns, fines and reporting.

Role
Full stack developer
Duration
4 months
Status
Completed
Library Management System main screenshot

Background

Loan records were kept in spreadsheets, making overdue tracking manual and error prone.

Problem

Staff could not tell which titles were available, and fine calculation was inconsistent between shifts.

Solution

A role-based Laravel application with barcode-driven circulation, automatic fine rules and a reporting module for collection usage.

Features

  • Barcode scan checkout and return
  • Automatic overdue fines
  • Member self-service portal
  • Collection usage analytics
  • Bulk catalogue import

Architecture

  1. 1Laravel MVC with service layer
  2. 2MySQL relational catalogue schema
  3. 3Queue worker for notification emails

Challenges

  • Migrating a messy spreadsheet catalogue required a deduplication pipeline.

Lessons Learned

  • Data migration is the project, not a task inside the project.

Gallery

Library Management System screenshot 1