Library-Management-System

Title: Library Management System - Streamlining Information Retrieval and Resource Management

Team Members:

1. Royas Shakya
2. Bibek Agrahari
3. Shubham Chitangia
4. Euristina Sharma Dhital

Project Description: For our high school project, our team undertook the task of developing a Command-Based User Interface(CUI) Library Management System (LMS) to enhance the efficiency and accessibility of our school's library. The main objective was to create a user-friendly digital platform that would facilitate seamless information retrieval, resource management, and a better overall library experience for students and staff alike. So, as to confirm that only an authenticated user is using the project. The user can search book based on book id, book name, or by author name. To help the user get the required books issued. To return the book before the last date without fine, or after the specified time duration with a late fine.

Key Features and Functionalities:

1. Issue books - It helps the user to get the required books issued to the students who are eligible. It also helps to keep proper records for the books issued and available to the library with date of issuance.
2. Add books - The admin can add books to the system by entering the details of the books and can even update the details.
3. Delete books - The user can remove old, lost or outdated books from the system and keep a proper record of deleted books with reason for removal.
4. Student details - The user can simply enable or disable students who violate the rules and regulations of the library. It helps the user to search and view the required students details from the system.
5. Book details - The user can search book based on book id, book name, or by author name.
6. Submit books and fine - To return the book before the last date without fine, or after the specified time duration with a calculated late fine. Its helps to keep record of all.
7. Total penalty and collection - It shows all the details of the books submitted in the system with total fine amount calculated within a range of time.
8. Logout - It terminates the system and user have to login again to use the system again.

Technology Used In Project:

1. My SQl 5.7.26(Back-end): MySQL is a database management system that is used to maintain relational databases. It is an open-source software backed by Oracle Corporation. As it is an open-source database system, the source code can be modified according to our needs. Here, we have use it to store data related to books, students and many more to DBMS.
2. Python 3.7.6 (Front end): Python is an interpreted, object-oriented, high-level programming language with dynamic semantics. Its high-level built-in data structures, combined with dynamic typing and dynamic binding, make it very attractive for Rapid Application Development, as well as for use as a scripting or glue language to connect existing components together. Python's simple, easy to learn syntax emphasizes readability and therefore reduces the cost of program maintenance. We have used Python for the development of the system using modulus for better efficiency and perform all the operations related to the system.
3. Microsoft Word: It is a word processing program, included with Microsoft Office, and it possesses an absolute dominance in its market. We have used MS Word mainly for documentation purpose.
4. Interface Python with MySQL: MySQl pyhton/connector is an interface for connecting to a MySQL database server from Python.It implements the pyhton database API and is built on top of the MySQL. The general workflow of a python program that interacts with a MySQL-based database is as follow: • Connect to the MySQL server. • Create a new database. • Connect to the newly created or an existing database. • Execute a SQL query and fetch result. • Inform the database if any changes are made to a table. • Close the connection to the MySQL server. A connection is established between Python file and MySQL server for the retrieval, manipulation and storage of data to DBMS through the instruction of the program.

Rules and Regulations of Library

Guidelines General Rules -No library material can be taken out of the library without permission. Unauthorized removal of anything belonging to the library will be treated as theft and dealt accordingly. -Any one who violates the rules and regulations of the library would be liable to lose the privilege of library membership and may be debarred from using the library facilities. -Suggestions on all aspects, of library services are welcome. -The library remains open throughout the school timings but the books cannot be returned or issue during lunch break (11:30-12:30) -The library may be closed during non-academic days of school. -No student will be allowed to avail library facility without valid ID card and library card. The borrower cards are not transferable -For availing library facility, students should be in proper uniform. Issue/Return Rules -Students are allowed to issue 1 maximum number of book, 7 maximum days of issue

Fine for late return books/journals -Books must be return on or before the due date otherwise the fine of Rs. 5 will be charged per day/book. -At the time of deposition of late fine you must collect receipt for the payment from the library. -Absence & illness are not acceptable excuses for exemption from paying overdue charges. -If the Due Date falls on holiday declare by collage, then students may return their books on the next week on scheduled day. -User(s) has to return all issued books when he/ she is out of station for more than fifteen days. -In spite of repeated reminders, if the book is not returned, the borrowing facility may be withdrawn for a period -decided by the authority. Also, if the student fails to deposit the issued book for more than 60 days from the date of due then he/she may have to pay the fine amount including the current MRP of the book. Renewal of books -Users can also renew the books again after the completion of charging period, subject to not being requested from some other user.

Login Page:

Output for different modulus: output cs.pdf