0% found this document useful (0 votes)
30 views3 pages

Sqlite3 Database

Uploaded by

PRANAV TIWARI
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
0% found this document useful (0 votes)
30 views3 pages

Sqlite3 Database

Uploaded by

PRANAV TIWARI
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd

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:

You might also like