π Student Library Management System
A command-line based Library Management System developed in Python, designed to manage book records and student interactions efficiently. This project showcases fundamental concepts of object-oriented programming and database integration, making it an excellent resource for beginners and educational purposes.
π Features
Book Management: Add, remove, and update book records. Student Management: Register students and manage their borrowing activities. Borrowing System: Issue and return books with due date tracking. Search Functionality: Search books by title, author, or ISBN. Database Integration: Utilizes SQL for persistent data storage.
- Programming Language: Python
- Database: SQL (Structured Query Language)
π Project Structure
Student-Library-Management-System/ βββ Student_Lib.py # Main application script βββ Table.sql # SQL script to set up the database schema βββ README.md # Project documentation
-
Clone the Repository:
bash git clone https://github.com/astro-prog/Student-Library-Management-System.git cd Student-Library-Management-System
-
Set Up the Database:
-
Ensure you have a SQL database system installed (e.g., MySQL, PostgreSQL).
-
Execute the
Table.sqlscript to create the necessary tables:bash mysql -u your_username -p your_database < Table.sql
-
-
Configure Database Connection:
- Update the database connection settings in
Student_Lib.pywith your credentials and database information.
- Update the database connection settings in
-
Run the Application:
bash python Student_Lib.py
π€ Contributing
Contributions are welcome! To contribute:
-
Fork the repository.
-
Create a new branch:
bash git checkout -b feature/YourFeature
-
Commit your changes:
bash git commit -m "Add your feature"
-
Push to the branch:
bash git push origin feature/YourFeature
-
Open a pull request detailing your changes.
Please do feel free to make changes wherever required
Built with β€οΈ by @astro-prog