Queensland International Business Academy - Library Management System

This assignment focuses on the development of a Library Management System, designed to automate and streamline library operations. The system incorporates a database and a GUI interface for managing books, borrowers, and other records. Key functionalities include adding and modifying book details (title, author, publication), storing author information, managing student details, and handling book reservations and returns. Security features such as user logins and password changes are also implemented. The system calculates fines for late returns and includes use case and class diagrams to illustrate the system's design. Screenshots demonstrate various features, including adding, editing, searching, and issuing books, as well as managing student records and calculating fines. References to relevant research papers are also provided.

[Pick the date]
[Type the document subtitle] | Kaw
[TYPE
THE
COMPAN
Y NAME]
ICT50715 - Diploma of Software
Development

INTRODUCTION
In this assignment, the library management system is used for managing the books, borrower and other
records. A library management system is developed for managing complex tasks and make the
operation is easy and simple. If the librarian makes the paperwork for all library operations it will make it
more difficult to manage to understand the flow of business. The software will help to overcome all this
problem. The library management system provides automation and makes operation convenient and
reduces the overhead of operations. It helps to time-saving and also reduces paperwork. A library
management system assists to maintain the customer relationship. It helps to manage and track the
borrower and borrowers' book details. The library management system includes the database and the
GUI interface. When the librarian enters the record it will store into database tables. Gui interface helps
to connect the user with the database.
In this assignment, focus on the following functionality
The library management system helps to add a new book with properties book name, books, the author
is publication, librarian Id, etc.
The library management system assists to store details of the author with attributes like Id and author-
name
It also helps to store the reserves book where we can enter the details of bookid , student I'd and other
related details.
We can also add the student detail including the student's first name, last name, suburb, city, state, etc.
We can add a new book and we can also modify the existing book details.
We can also add new student detail and edit the existing book details.

For security purposes, the library management system includes login details credential where users can
make a login into the system and librarians can change the password.
Librarians can search the book details by using author name and title.
Librarian can get returns to book from borrower and librarian system can remove the record from
borrower tables and update the copy of the book and available book in the system
The library system also calculates the fine according to the return day. If the return date is greater than
the actual return date then fine will be calculated according to the number if the late day and multiply
by the fine value and finally calculate the actual fine.
In the library management system, Main is the MDI parent form which is parent form and another form
like, add the book, edit book, author, borrower, etc. are child forms.
To create an MDI parent form, I did change the ISMDI parent properly true.
Use case diagram
There 3 types of the actor in our system
1.Librarian: the library is a very important factor in the library management system. Librarian is
responsible for add new books,modify books,delete a book, return the book, issue book and add new
authors.
2.Student:
The student is another primary actor who is responsible for the request to issue books and return the
book.

3.System: It is responsible for manage reserves book, issue and calculate, etc.
In below, we can see the top use case
Add/modify :
In this case, the librarian can add a new book and allow it to modify the existing book.
Search:
In this use case, we can search the book by author name and title of the book
Register new librarian
In this use case, we can add new records of a new librarian where librarian details must enter with
username and password
Checkout book: Here, the student can borrow the book from the library.
Reserve book:Here,we can make a book reserve which is not available in the system.
Return book: In this use case, the student can make the return book that has borrowed.

Class diagram

There is a various class in our library management system are:
Library: This is the foundation of the software design. To distinguish it from other libraries, its properties
such as name and address attributes can be specified.
Books: Computer-aided building blocks. Each book has an ISBN, a title, an article, and a publisher.
Book items: Each book can have multiple copies and each book is an item in our system.
Accounts: Here, we have an admin account i.e librarian.
Library Card: Each library user is provided with a library card that identifies the user when the book is
distributed or returned.
Subject: Booking Reservation: Responsible for solving problems with the bookstore.
Book Balance: Manage book item updates
Catalog: Contains a list of catalogs arranged according to specific criteria. Our system will help you find
four titles, F-editor, articles and release date.
Fine: In this function, we can calculate the fine and display find as per late date

Login
In above, we can see the login form where the user must enter the username and password
if wrong id and password

In the above screenshot, we can see that if the user enters the wrong username and password, the
system does not allow us to enter into the system.

After login
If the user enters the valid username and password then the system enters into the system and the
system will redirect to the MAIN MDI parent form.

Student
Above,we can see the various category of the menu.
In the Student master, we can see the menu like add a new student menu. In this menu, add new
student form will be open where the user can enter details of the student.

Add Student
Here, we can see how to create the new student

Edit Student
here, we can make an edit to the existing student

Book
Add New book
Here we can add a new book.

New books added into the database and show the notification.

Edit
Here we edit the existing book. Before the edit, we must search the record and if the wrong ISBN enters
it will show no record found the message.

Update price

Issue Book
In the above screenshot, we can see book issues and the system will update the available book copies.

In the above, we can see the issue book by the librarian.

Here we can see the update number of available and number borrowed copy.

Reserve Book
here, we can see, how to do the reserve book

Reserve Book Record

Return Book
Here, we can check how to do a return book.

Record delete
After retune book record will be delete form issue and update the number of available and a number of
borrower quantity in the database.

After update

Search book

Author

Change Password

References
1. QIAN Xiao-Hua,Geng Cai-Feng.The Building of Library Management System in B/S Structure
Based on J2EE[J]. Journal of Liaoning University Natural Science Edition,2009,34(4):12-15
2. Zong Wei.Research for Modeling the High School Library Management System Based on
UML[J].Computer Science, 2011,20(12):9-13
3. Yan Lin. The library management information system[D].Electronic and Science and Technology
University, 2008
4. Ming-hui LIU.Research and Design on Library Management System Based on
Framework[J].Journal of Anhui University Natural Science Edition,2009,33(3):36-40