Skip to content

Online Library Management System built using MySQL and Python

Notifications You must be signed in to change notification settings

Aseem2004/Library-Management-System

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

37 Commits
 
 
 
 

Repository files navigation

Library Management System

The Online Library Management System is a comprehensive software solution designed to streamline library operations. Built using MySQL and Python, the system offers a wide range of features to enhance user experience and efficiency.

Users can easily create new accounts, update their information, and manage their borrowing history. Librarians have access to tools for adding new books, updating existing records, and managing lending and return processes. The system also includes features for tracking lending history, managing orders for new books, and generating reports for analysis.

With its user-friendly interface and robust functionality, the Online Library Management System is a valuable tool for libraries looking to modernize their operations and provide a seamless experience for patrons.

Features

  • Create a New Account: Users can create a new account to access the library system.
  • See Account Info: Users can view their account information.
  • Update Card Holder Info: Users can update their card holder information.
  • Delete Account: Users can delete their account.
  • Add New Books: Users can add new books to the cart.
  • See All Books: Users can view all the books available in the cart.
  • Update Book Details: Librarians can update the details of existing books.
  • Delete Book: Users can delete books from the cart.
  • Lend a Book: Librarians can lend books to users.
  • Return Book: Users can return books to the library.
  • Display Lending History: Users can view their lending history.
  • Order New Book: Users can order new books to be added to the library.
  • Update Order Details: Librarians can update the details of book orders.
  • Display Order History: Users can view their order history.
  • Exit the Program: Users can exit the program.

Technologies Used

  • MySQL: For storing user accounts, book information, lending history, and order history.
  • Python: For building the application logic and user interface.

How to Use

  1. Installation:
    • Install MySQL and Python on your system.
    • Connect MySQL with Python and install MySQL Connector using PIP.
  2. Running the Application:
    • Run the Python application to start the Online Library Management System.
    • Application will run on the Python environment.
  3. Functionality:
    • Use the provided features to manage library operations efficiently.
    • Subsequent database will also be created and updated based on your activity.

Output

These are screenshots of the output rendered with some test values.

op01 op02 op03 op04 op05 op06 op07 op08 op09 op10 op11 op12 op13

Contributing

Contributions to this project are welcome! If you have any suggestions or improvements, feel free to fork the repository and submit a pull request.

About

Online Library Management System built using MySQL and Python

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published

Languages