README.md

Library Management System (DBMS Project)

This repository contains a Database Management System (DBMS) project for a Library Management System. The system is designed to efficiently manage the operations of a library including adding, issuing, editing, returning, and deleting books, as well as providing functionality for user login, signup, and password management.

Features:

1. Login: Users can securely log in to access the system.
2. Signup: New users can create an account to access the system.
3. Add Books: Librarians can add new books to the library database.
4. Issue Books: Librarians can issue books to library members.
5. Edit Books: Librarians can edit the details of existing books.
6. Return Books: Library members can return borrowed books.
7. Delete Books: Librarians can remove books from the library database.
8. Search Books: Librarians can search the specific book from a list of available books in the library.
9. Show Books: Users can view the list of available books in the library.
10. Change Password: Users can change their login password for security purposes.

Usage:

1. Setup: Clone the repository and set up the required database.
2. Login/Signup: Users can log in with existing credentials or sign up for a new account.
3. Dashboard Portal: After logging in, users will be directed to the dashboard portal to access the various features mentioned above.
4. Perform Operations: Users can perform operations such as adding, issuing, editing, returning, deleting, and viewing books as per their role (librarian or library member).
5. Change Password: Users can change passwords for enhanced security.

Technologies Used:

• Backend: Python, Flask

• Database: PostgreSQL

• Frontend: HTML, CSS, JavaScript

• Dependencies: psycopg2 (Python PostgreSQL adapter), Flask-WTF (Form validation), Flask-Login (User authentication), etc.

• Setup Instructions

1. Clone the repository: git clone [email protected]:AfnanBinAbbas/DBMS-Mini-Library.git
2. Install dependencies: pip install -r requirements.txt
3. Set up the PostgreSQL database: Configure the connection in config.py.
4. Run the application: python app.py
5. Access the application: Visit http://localhost:5000 in your web browser.

Contributors:

1. https://github.com/naqirraza99
2. https://github.com/AfnanBinAbbas

License:

Refer to LICENSE.txt

For detailed instructions on setting up and using the Library Management System, refer to the documentation provided in the repository. Feel free to contribute to the project by submitting bug fixes, feature enhancements, or suggestions via pull requests.

Happy coding and happy reading! 📚

Frontend of Library Management System:

Landing Page:

Home Page:

Login Page:

SignUp Page:

Library Catalog:

Featured Books:

Browse Books:

Dashboard Portal:

Add Books:

Issue Books:

Edit Books:

Return Books:

Delete Books:

Search Books:

Show Books:

Change Password: