User Guide LMS

User Manual:

Open the PDF directly: View PDF PDF.
Page Count: 2

DownloadUser Guide - LMS
Open PDF In BrowserView PDF
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”.
Source Exif Data: 
File Type                       : PDF
File Type Extension             : pdf
MIME Type                       : application/pdf
PDF Version                     : 1.7
Linearized                      : No
Page Count                      : 2
Language                        : en-US
Tagged PDF                      : Yes
XMP Toolkit                     : 3.1-701
Producer                        : Microsoft® Word 2016
Creator                         : Pallavi Sinha
Creator Tool                    : Microsoft® Word 2016
Create Date                     : 2018:07:12 06:29:21-05:00
Modify Date                     : 2018:07:12 06:29:21-05:00
Document ID                     : uuid:29CC3697-8B6C-443D-8FA3-B47A85DEA2E6
Instance ID                     : uuid:29CC3697-8B6C-443D-8FA3-B47A85DEA2E6
Author                          : Pallavi Sinha
EXIF Metadata provided by EXIF.tools

Navigation menu