☑Kizspy.me
The Mysterious woman Mystery
Figure 1. The Main Window.
View Borrowers
2. BorrowingHistoryDetails Window (See Figure 2)
•
Displays detailed information about the selected book, including:
o
Bookld: Book identifier.
°
Title: Book title.
°
•
•
•
GenreName: the genre of the book.
Copy List: Lists all copies of the book from the BookCopies table, including:
о
Copyld: The copy identifier
° Status: The current status of the copy: "Avaiable" or "Borrowed".
Borrowing History: when user click on a copy in Copy List, displays the borrowing history for a
selected copy (uses data in BorrowHistory table), including:
o
°
°
о
Borrowerld: The borrower's unique identifier.
BorrowerName: The borrower's name.
BorrowDate: The date the copy was borrowed.
Return Date. The date the copy was returned (if returned).
When user chooses a borrowing record in Borrowing History, then clicks the "Return" button for
a selected copy:
о
°
0
Verifies if the copy is currently borrowed (i.e., an active record exists
in BorrowHistory with ReturnDate as NULL).
If borrowed, updates the ReturnDate to the current date and changes the
copy's Status to "Available" (in Copy List).
If not borrowed, displays an appropriate message.
Zoom
- FUO
+ 100%
Close
