Issue Library Book
Links MemberID and BookID in BorrowRecords with relational integrity checks.
Automated Validation Rules Executed Before Issue:
1. Blocks transaction if member holds any unreturned Overdue books.
2. Blocks transaction if book stock is 0 Available Copies or member quota is full.
3. Automatically stamps IssueDate (2026-11-09) and DueDate (2026-11-23) (+14 days).
Current Active Loans
Live join of BorrowRecords, Books, and Members
| Loan ID | Book & Rack | Borrower | Issued → Due | Status |
|---|