User Guide LMS
User Manual:
Open the PDF directly: View PDF 
.
Page Count: 2
LIBRARY MANAGEMENT SYSTEM
USER GUIDE
This SQL programming project involves the creation of a database host application that
interfaces with a backend SQL database implementing a Library Management System. Users of
the system are understood to be librarians.
This document is used by librarians to become familiar with the library management system
environment.
The Index Page is as follows. It provides links to all other pages of the system such as.
1. Search Books
2. Check-In Books
3. Add Borrower
4. Fines
Search Books:
In the search box on the GUI enter ISBN or title, and / or Author and click on ‘Search’. The search
displays ISBN, Title, Author(s), and availability of the book. The application supports sub-string matching.
The user can check out desired book by entering the Borrower Card ID.
Check-In Books:
Enter ISBN number or Borrower name or Borrower Card ID and click on ‘Search’ to check-in the
borrowed books.
Add Borrower:
New borrowers can be added in the system. All the input fields are mandatory. Click on Add once all the
fields are filled. The system will allow to the user to sign up and a Card ID is assigned to the new user, if
SSN entered in unique.
Otherwise it will show an appropriate error message.
Fines:
There are 3 links on the Fines page :
1. Update Fines
2. Pay Fines using CardID.
3. Paid Fines
Update Fine: When clicked on “Update Fines” button, the fines table will be updated till current date.
Pay Fines using CardID: Enter CardID and pay fines for the checked-in books.
Note: Fines for books which are not checked in cannot be paid.
Paid Fines: When clicked on Paid Fines button, it will show all the payments done by the borrowers
previously. If there is nothing to display, it displays “No results”.
