Back to Projects

Digital Library Management System

Completed
Database
Sep 2024 – Dec 2024

Overview

Multi-branch library management with relational schema, triggers, stored procedures.

Highlights

  • •10-entity relational schema
  • •Triggers for loan dates, reservation checks, membership expiration, fines restriction
  • •BorrowBook stored procedure with transactions + rollback on errors
  • •Web access module for borrow/reserve operations

Tech Stack

SQL
PythonPython
Triggers
Stored Procedures

Related Projects