Computer Practical Project 2021
Table of Contents
Name: Library Management system
Version: 1.0
1 Overview
Following is a document listing the features of a Library Management System that was built after being frustrated by the manual handling of data at the local library. The features include a system to manage a database of books, Admins and Clients, and the ability to modify, sort and export relevant data. The document also includes basic instructions if one wants to modify the program
2 Objective
To Build a Library management system that is easy to use and provides a hassel free experience
- Built with Python and QT Framework
- Python Modules:
- wheel
- pyqt5
- pymysql
- xlrd
- xlsxwriter
- datetime
- Python Modules:
- MySQL Database Hosted on Clever Cloud with IP Authentication
2.1 Releases
3 Features
3.1 Main system
- Login Page
- Users
- Add Users (Signup)
- Add a Book
- Edit Book Info
- Delete Book
- Categories
- Settings [Categs, Author, Publisher]
- Day To Day Transaction Log
- Reports [Excel Files]
3.2 Book
- Title
- ISBN Code
- Description
- Category
- Price
- Author
- Publisher
3.3 Admin
- User Name
- Password
- Email Id
3.4 Client / Students
- Username
- Student ID
- Email ID
3.5 Day-to-Day
- Book name
- Type (Issue / Return)
- Duration (weeks)
3.6 Category, Publisher, Author
- Names
- List
4 Future Prospects
- WebApp
- Integrate barcode scanning
- Ability to select local or cloud database
5 Resources
5.1 Requirements
5.1.1 QtDesigner
If you want to edit the .ui files ie the actual LOOK or LAYOUT
- Install on Windows
- Install on Mac
- Installing on Linux (Debian and Fedora)
sudo apt-get install qttools5-dev-tools qttools5-dev sudo dnf install qttools5-dev-tools qttools5-dev
5.1.2 Python Dependencies
To install python dependencies use the requirements.txt file with python pip
5.2 Icon Manipulation:
Follow these steps to change hte programs icons
- Keep the same name (for ease)
In the folder, open terminal and run the following code
pyrcc5 icons.qrc -o icons_rc.py