University Library Management System

Library loan and return management system with user management and penalty tracking.

Project overview

Design and development of a complete loan and return management system for a university library, including user management, borrowing tracking, overdue tracking, and penalty calculation.

Current state

Functional application with user, loan, and penalty modules.
Normalized relational schema and advanced SQL queries.
Feature testing and validation completed.
Technical documentation produced.

Tech stack

PythonSQLPostgreSQLUML

Tags & Code

BackendSQLPythonBase de données

Private code (academic project)

Vision

Automate and secure book loan and return management.
Ensure rigorous overdue and penalty tracking.
Produce a solid relational schema and optimized SQL queries.

Architecture

User modules: registration, authentication, profile management.
Loan management: creation, consultation, return, and history.
Automatic overdue and penalty calculation based on business rules.
Normalized relational schema and advanced SQL queries for reporting.
Application of object-oriented design principles.

Roadmap

Phase 1: relational schema design and UML modeling.
Phase 2: user and loan module development.
Phase 3: overdue and penalty rule implementation.
Phase 4: testing, validation, and technical documentation.

Engineering decisions

PostgreSQL for relational robustness and advanced query management.
Schema normalization to avoid redundancy and ensure data integrity.
Object-oriented design for a clear and maintainable architecture.

Possible improvements

Add a graphical interface for librarians.
Integrate advanced search by author, genre, or availability.
Generate statistical reports on borrowings.

Lessons learned

Upfront relational schema design is crucial for data consistency.
Advanced SQL queries (joins, aggregates) are essential for meaningful reports.
Technical documentation facilitates system maintenance and evolution.

← All projects Contact me