Relational DBMS & Catalog Architecture

LIBRA X Academic Literature & Library Management

A normalized database management application engineered for book discovery, copy tracking, real-time reservations, and automated circulation.

Catalog, Loans & Wishlist

Search books, check shelf availability, view due dates, manage waitlists, and explore recommendations.

Circulation & Analytics

Issue/return physical copies, automatic overdue fine calculations, catalog inventory, and DBMS reports.

Database Architecture & System Highlights

Strict 3NF database design featuring Book-to-Copies 1:N relations, many-to-many Book-Authors, and transactional referential integrity.

Triggers simulate live copy status updates (`available` ⇄ `borrowed`), fine computing on overdue transactions, and reservation queues.

Content-filtering recommendation engine based on user borrow history and category affinity analysis.