Project Report:
Library Management System MAD-1 Project
Author: Pranav Tiwari
Roll number: 22f3001519
Institute e-mail id: 22f3001519@[Link]
Project Description:
It is a multi-user app (one required librarian and other general users/students) used for issuing e-books to
users, a user can request, read, return e-books. Librarians can add new sections/e-books, issue/revoke
access for a book. Every section can have a number of books, the system will automatically show recently
added sections/books or based on certain rating.
Technologies Used:
• Flask - web framework
• Jinja2 - templating engine
• Bootstrap - for HTML and CSS styling
• SQLite - for data storage
• SQLAlchemy – ORM mapper to manage data using python.
• Flask RESTful API – API library form API endpoint implementation
Functionalities:
• Librarian login and User login/Register with Authentication.
• Librarian has the ability to add new Sections/Books and to edit and delete them.
• Search functionality implemented in the Book store for users convenience and ask request the book
for access
• The user can also download the book in form of PDF.
• Librarian haas the ability to revoke access of a book from the user at any point of time
• The access of the book will automatically be revoked if the requested time period has passed
• The user can give feedback about the book that have been issued to them and also give rating to the
book
• CRUD based working of Users, Books, Sections, Feedbacks and Requests.
• Basic stats in Admin dashboard
• The books store only shows the book that has not been requested by the user
• A user can only provide one feedback to a certain book
Database Schema Design:
Challenges Faced:
• Requirements Gathering
• Data Modeling
Video link: