A Mini-School Group Project
A library management system using Python-SQL connectivity.
Funnily enough, we didn't realize that this was a small implementation of CRUD operations!
A library management system is software that is designed to manage all the functions of a library. It helps maintain the details of all books, employees, members and the books borrowed by the members.
A well-developed database management system makes things very informative and simple for both the readers and the librarians.
A database which gives an in-depth information books borrowed by each of the readers , and helps to learn their interests. This will also enable the librarians to track the books efficiently, and prevent any loss or damage of books.
• Windows OS/Mac OS • Python 3.4 or higher • MySQL 8.0 or higher
Username: root
Password: pswd@123
Tkinter Module: Tkinter is a Python binding to the Tk GUI toolkit. It is the standard Python interface to the Tk GUI toolkit, and is Python's de facto standard GUI. Tkinter is included with standard Linux, Microsoft Windows and Mac OS X installs of Python. The name Tkinter comes from Tk interface.
Date Time Module: In python, date and time are not a data type of their own, but a module named datetime can be imported to work with date and time. This module supplies classes to work with date and time, these classes provide a number of functions to deal with dates, times and time intervals.
MySQL Connector Module: MySQL Connector enables Python programs to access MySQL databases, using an API that is compliant with the Python Database API Specification v2.0 (PEP 249). It is written in pure Python and does not have any dependencies except for Python Standard Library.
Here, the MySQL. Connector module has been used to allow users to interact with the LDMS database which is present in MySQL through the python front end.
The objective of this project is to let students apply their programming knowledge into a real - world situation/problem and expose the students how programming skills help in developing a good software. • Write programs utilizing modern software tools. • Apply object-oriented programming principles effectively when developing small to medium sized projects. • Write effective procedural code to solve small to medium sized problems.
The simplicity of creation of a database depends on the type of information stored in it. A library management database is a software system where the management of the entire library is computerized. the application stores reader record and borrowing activities performed in the library such as reader details, books borrowed, issued date, return date, penalty, etc. all are computerized and the management is done without any difficulty with the use of Python modules and directories.
The system maintains the different location that is available and registered to a central database which leads easy accessibility and consistency. Each accommodation available units and all the unit facilities are available at the click of a mouse The registration for a user is done online making it more efficient and convenient for the registration process. The readers are provided with accurate details regarding their borrowing history. This application allows the library management the ability to operate the entire system from a single online interface, giving them more power and flexibility. Maintain a steady influx of visitors and guests throughout the year, as well as top promote the library’s extensive rang e of services. Better safety and security in maintaining data and personal information using automation
As the technology and the passion of being well read is increasing day by day, the need for a well-organized, computer-based library management system has become the need of the society. This system helps the admin and the librarian to maintain large data about the users and their daily activity in the library. It should be suitable for maintaining records about the books borrowed, issued and returned.
In the library management system, if we take the conventional system and compare it with the proposed system, it is far behind. Every work in a conventional system is manual and done on paper and the computer systems do not function efficiently, leading to the need of tedious manual work. Some major drawbacks of the existing conventional system are as follows: • Requires a lot of paperwork and the process takes time. • Everything is done on paper, which is highly prone to damage and requires a good amount of security and space to store. • Requires buying of goods more frequently as compared to the online system • Likely to have an error • Lack of storage space for handwritten documents • Requires more physical work and manpower • Information is not available globally to both clients and employees hence location restriction
The system that we shall be proposing in this project not only corrects the drawbacks of the existing system, but it also provides a whole slew of new facilitates and opportunities to take advantage of. Data will be fed to the database from input devices. This will be processed (if needed) and stored in a centralized memory and will be accessible to the library staff. Output will be given by the database itself on demand. The software that will be used for managing the database will be MySQL, and the front end will be designed using Python.
In no manner, I claim "complete" ownership of this project.
Apart from the efforts by me and my two other teammates (say, S and H), the success of any project depends largely on the encouragement and guidelines of many others. Hence, I take this opportunity to express my gratitude to the people (parents & teachers) who have been instrumental and contributed in bringing this project up to this level, as well as in assisting with the successful completion of this project.
Thanks for checking out this.