Skip to content

README.md

Latest commit

 

History

History
74 lines (58 loc) · 3.61 KB

README.md

File metadata and controls

74 lines (58 loc) · 3.61 KB

Library Management System (Database Management)

Project Overview

The Library Management System is a Python-based project designed to manage a library's operations, including user management, book management, and penalty management. The system uses SQLite for persistent data storage and provides a user-friendly interface for both users and administrators.

Features

  • User Management: Allows users to register, log in, and view their profiles.
  • Book Management: Users can search, borrow, return books, and leave reviews.
  • Penalty Management: Tracks penalties for overdue books and allows users to pay fines.
  • SQLite Integration: All data is stored in an SQLite database, managed seamlessly by the system.

Project Structure

  • /src/: Source code directory
    • main.py: Main entry point of the application
    • bookManagement.py: Book management module
    • penaltyManagement.py: Penalty management module
    • userManagement.py: User management module
    • utils.py: Utility functions used across the project
    • dbSetup.py: Database setup and initialization
  • /sql/: Directory for SQL-related files
    • mp1-schema.sql.txt: SQL schema for the database
  • /data/: Data directory
    • test.db: SQLite database file
  • README.md: Project documentation

Requirements

  • Python 3.x
  • SQLite (No external dependencies required)

Installation

  1. Clone the repository: 
    git clone https://github.com/PrthD/Library-Management-System-Database-Management.git
  2. Navigate to the src/ directory: 
    cd Library-Management-System-Database-Management/src
  3. Run the main application: The main.py script will handle database initialization automatically using the schema and data files. Execute the following command: 
    python3 main.py ../sql/mp1-schema.sql.txt ../data/test.db
    This command will launch the Library Management System's user interface.

Usage

Main Menu Options:

  • Login: If you're an existing user, select this option to log in by providing your email and password.
  • Register: New users can create an account by entering details like email, password, name, birth year (optional), and faculty (optional).
  • Exit: Select this option to exit the program.

After Logging In:

Once logged in, you’ll see additional options in the user menu:

  • View Profile: Displays your user profile, including details like name, email, birth year, faculty, and borrowing and penalty history.
  • Search for Books: Allows you to search for books by keywords. You can view book details and check the availability for borrowing.
  • Borrow a Book: Borrow a book by entering its book ID, provided it is available.
  • Return a Book: View your currently borrowed books and return any book. If a book is overdue, the system will apply penalties.
  • Pay a Penalty: View outstanding penalties and make payments either partially or in full.
  • Logout: Logs you out and returns you to the main menu.

Input Validation:

The system provides input validation to ensure smooth interaction, guiding you through correct usage and preventing common input errors.

Database Schema

The database schema is defined in sql/mp1-schema.sql.txt. It contains the following tables:

  • Members: Stores user information (email, password, name, birth year, and faculty).
  • Books: Stores book details (book ID, title, author, and publication year).
  • Borrowings: Tracks book borrowing activity (book ID, start and end dates).
  • Penalties: Tracks penalties for overdue book returns.
  • Reviews: Stores user-submitted book reviews and ratings.