WebFeatured ProjectStatus: Completed19 Stars

BookSphere MITAOE

Modern digitized library management and automated book reservation system for MITAOE.

My RoleLead Backend & Database Architect

Timeline / Duration3 Months

Team Structure4 Students (College Capstone)

THE CORE PROBLEM

Engineering students faced long wait times for textbook checkout during semester exams, and the college lacked a central search portal showing available rack positions.

THE ENGINEERED SOLUTION

Engineered BookSphere MITAOE with real-time ISBN lookup, barcode generation for mobile check-in, automated late return penalty calculation, and departmental reading lists.

PRODUCT CAPABILITIES

Key Features & Engineering Highlights

Instant book availability radar with exact shelf and rack coordinate locators

Student dashboard with 1-click book renewal and due-date countdown alerts

Librarian administrative dashboard with bulk CSV book import and circulation analytics

Department-wise curriculum syllabus book tagging (Computer, Electronics, Mechanical)

Technology Stack

ReactNode.jsExpressMySQLTailwind CSSJWT AuthChart.js

SYSTEM DESIGN

Technical Architecture

Relational database schema enforcing strict foreign key constraints between Students, Book Editions, Circulation Transactions, and Department Catalogs.

Client Portal

Dual view for Students (Search & Reserve) and Librarians (Scan & Issue).

React SPATailwind UIQR / Barcode Scanner

API & Business Logic

Handles daily penalty checks, email notification triggers, and circulation logging.

Node.jsExpressJWT AuthenticationSchedule Cron Jobs

Relational Database

Guarantees transaction consistency during concurrent student book holds.

MySQLStored ProceduresNormalized 3NF Tables

DEEP DIVE CHALLENGES