Portfolio
Library Management System
Schema

Dashboard

Overview of the library's activity right now.

Total Titles
Copies in System
Active Loans
Overdue
Members
Branches

Loans by Branch

Recent Activity

Books

Browse the full catalog. Click any row for details, copies at each branch, and loan history.

ID Title Author(s) Publisher Copies Available

Borrowers

Library members. Click a name to see their active loans and history.

Card # Name Phone Address Active Loans

Loans

All active loans across every branch. Click Return to check a book back in.

Book Borrower Branch Checked Out Due Status

Check Out a Book

Loan a book to a borrower. Loan period defaults to 30 days.

Reports

Analytics powered by the same queries as the original stored procedures.

Most-Loaned Books

Top 5

Most Active Borrowers

Top 5

Borrowers with No Loans

Overdue Loans