Library Management Project
Database-driven management application built on normalized relational schema design (1NF–3NF).
My Role
Developer
Category
Laravel Academic Project
Timeline / Date
Academic Project
Primary Stack
PHP & Laravel
01 / The Problem
The Operational & Engineering Challenge
Manual book cataloging and paper checkout logs cause inventory discrepancies, unrecorded overdue fines, and redundant data storage across multi-entity academic records.
02 / The Solution
Architecture & System Implementation
Developed a database-driven Laravel MVC management system designed around a strictly normalized (1NF–3NF) MySQL relational schema. Provides role-based access control for librarians and students, automated inventory tracking, and full CRUD record administration.
03 / Platform Showcase
Library Management Public Catalog & Book Search Portal
Public catalog interface featuring instant category filtering, keyword and ISBN search, real-time availability counters, and direct student borrowing interactions.
04 / Key Features
Core System Capabilities & Workflows
Normalized MySQL relational schema design (1NF, 2NF, 3NF).
Feature 01
Structured Laravel MVC architecture and business logic.
Feature 02
Role-based access control for librarians and students.
Feature 03
Full CRUD record-management and inventory tracking.
Feature 04
Eloquent ORM relationships and query optimization.
Feature 05
Published and maintained the source code on GitHub.
Feature 06
05 / System Overview & Dashboard
Librarian Administrative Control & Book Inventory Management
Comprehensive administrative book ledger showcasing relational data records with cover thumbnails, ISBN codes, author mappings, categorization, publication years, real-time availability statuses, and full CRUD control actions (View, Edit, Delete).
08 / Engineering Contribution
My Specific Role & Responsibilities
Full Stack Developer responsible for relational database schema normalization (1NF–3NF), Laravel MVC architecture, Eloquent ORM configuration, role-based authentication, and inventory checkout workflows.
09 / Technology Architecture
Full-Stack Technology Decisions
Backend & APIs
- Laravel
- PHP
- MVC Architecture
- Eloquent ORM
Frontend & UI
- Blade Templates
- HTML5
- CSS3
- JavaScript
Database Layer
- MySQL
- Relational Normalization (1NF–3NF)
- SQL Indexing
Integrations & Tools
- Git
- GitHub
- MySQL Workbench
10 / Data Layer
Database Architecture & Relational Schema
Strictly normalized relational schema eliminating redundancy and anomalies across multi-table book, author, category, and borrowing records.
Key Relational Entities
- books: Central catalog records with ISBN, title, total copies, and available copies
- authors & categories: Normalized lookup tables preventing duplicate string storage
- students: Student member registry with borrowing privileges and limits
- borrow_records: Transactional ledger tracking checkout dates, due dates, and return statuses
Schema Design Principles
- Full 3NF normalization eliminating duplicate author/category attributes
- Composite foreign keys on borrow_records linking student_id and book_id
- Referential integrity rules preventing deletion of books currently on loan
11 / System Flow
API Architecture & Data Flow Lifecycle
Standard Laravel MVC request-response lifecycle with session-based security and transactional database mutations.
12 / Problem Solving
Engineering Challenges & Technical Solutions
Challenge 01
Preventing N+1 query performance degradation when listing multi-author and categorized book catalogs.
Engineered Solution:
Utilized Eloquent eager loading (with()) across related author and category models, minimizing query overhead to a single efficient join.
Challenge 02
Maintaining exact available inventory count during concurrent student checkouts.
Engineered Solution:
Enforced atomic quantity checks and database transaction wrapping before checkout records are saved.
13 / Result & Verification
Project Delivery & Technical Achievements
Successfully demonstrated database normalization principles, clean Laravel MVC separation of concerns, and reliable CRUD administration.
- Demonstrated 1NF–3NF normalized relational schema design
- Robust multi-role CRUD catalog and checkout tracking
- Public repository maintained on GitHub