Scribd
Upload
20 views5 pages

Synopsis On Library Management System-1

Uploaded by

Shivu Shivu
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
20 views5 pages

Synopsis On Library Management System-1

Uploaded by

Shivu Shivu
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
You are on page 1/ 5

MYSORE COLLEGE OF ENGINEERING AND

MANAGEMENT,MYSORE

MINI PROJECT SYNOPSIS(21CSMP67)

SUBMITTED BY,

STUDENT DETAILS:

PRAJWAL P SHANKAR(4MO21CS035)

RAGHAVENDRA K(4MO21CS038)

SHIVANAGA V(4MO21CS047)

PREMKUMAR S B(4MO22CS409)

SEMESTER:

6th (3RD YEAR)

BRANCH:

COMPUTER SCIENCE AND ENGINEERING

TOPIC:

LIBRARY MANAGEMENT SYSTEM USING PYTHON

SUBMITTED TO,

PROF. JAYARAM CV (DEPT OF CSE)


1.INTRODUCTION: -

A library management system is software that is designed to manage all the functions of a
library. It helps librarian to maintain the database of new books and the books that are borrowed
by members along with their due dates.

This system completely automates all your library’s activities. The best way to maintain,
organize, and handle countless books systematically is to implement a library management
system software.

A library management system is used to maintain library records. It tracks the records of the
number of books in the library, how many books are issued, or how many books have been
returned or renewed or late fine charges, etc.

You can find books in an instant, issue/reissue books quickly, and manage all the data
efficiently and orderly using this system. The purpose of a library management system is to
provide instant and accurate data regarding any type of book, thereby saving a lot of time and
effort

2.PURPOSE: -
The "Library Management System" has been developed to override the problems prevailing in
the practicing manual system. This software is supported to eliminate and, in some cases,
reduce the hardships faced by this existing system. Moreover, this system is designed for the
particular need of the company to carry out operations in a smooth and effective manner. The
application is reduced as much as possible to avoid errors while entering the data. It also
provides error message while entering invalid data. No formal knowledge is needed for the
user to use this system. Thus, by this all it proves it is user-friendly. Library Management
System, as described above, can lead to error free, secure, reliable and fast management system.
It can assist the user to concentrate on their other activities rather to concentrate on the record
keeping. Thus, it will help organization in better utilization of resources.
3.FEATURES OF LIBRARY MANAGEMENT SYSTEM:
1. Add new books to the database.
2. Issue books to the users or students.
3. Take borrowed books from the users or students.
4. Issue the book again to the person who is already holding that book.
5. Displays all the book records presented in the library with the total available piece of
each book (It shows all the records in a table view format).
6. Search a book by name. In this case, if the users don’t know the full name of the
book, they can search by only a word or characters instead.
7. Update and delete the book records.
8. Displays the records of all the borrowers with the related information.

4.ADVANTAGES: -

➢ Student do not have to wait in long queues.


➢ Librarian does not need to worry about the books.
➢ This Software reduces the paper work.
➢ It is easy to handle student’s record.
➢ This software saves the time.
➢ Easy to use
➢ User friendly environment.

5.DISADVANTAGES: -

➢ Sometimes books are not available.


➢ Costly and expensive.
➢ Risk of computer virus.
6.SOFTWARE USED:

➢ Visual Studio Code


➢ MySQL Command Line 8.0
➢ Python 3.12
➢ TKinter

7.HARDWARE USED:

➢ OS-Windows 11
➢ RAM-8GB

8.FRONT END:

➢ Python 3.12
➢ Visual Studio Code
➢ Tkinter

9.BACKEND:

➢ MySQL

10.DATABASE:

➢ Library_Management

10.TABLES:

➢ BOOK_LIST
➢ BORROW_RECORD
11.CREATION OF TABLES:

➢ create table book_list( book_id VARCHAR(10) NOT NULL, book_name


VARCHAR(50) NOT NULL, author VARCHAR(50) NOT NULL, edition
VARCHAR(10) NOT NULL, price Int(6) NOT NULL, qty Int(4) NOT NULL,
PRIMARY KEY ( book_id ) );
➢ create table borrow_record( book_id VARCHAR(10) NOT NULL, book_name
VARCHAR(50) NOT NULL, stu_roll VARCHAR(15) NOT NULL, stu_name
VARCHAR(50) NOT NULL, course VARCHAR(10) NOT NULL, subject
VARCHAR(30) NOT NULL, issue_date date NOT NULL, return_date date NOT
NULL );

12.CONCLUSION:

The Library Management System is a software solution that helps manage the daily operations
of a library. It is designed to automate routine tasks, such as cataloguing, circulation,
acquisitions, and inventory management, which enables librarians to focus on providing better
services to their patrons.

Many formalities come under library management. A Library Management System can bring
several benefits here. For growing knowledge and enhancing skills to solve real-life problems
I developed a Library Management System Project in Python using Tkinter and MySQL.

You might also like