Remember to take your time and work through each question diligently! Test your code, make sure it works, and try to find ways to improve. Once you are happy and satisfied with your code, upload it to Github, then turn in your Github link at the bottom of the page!

Don't forget. Make sure this assignment is in it's own repository. Not mixed in with others!

Project Requirements

In this project, you will integrate a MySQL database with Python to develop an advanced Library Management System. This command-line-based application is designed to streamline the management of books and resources within a library. Your mission is to create a robust system that allows users to browse, borrow, return, and explore a collection of books while demonstrating your proficiency in database integration, SQL, and Python.

Integration with the "Library Management System" Project from Module 4 (OOP):

For this project, you will build upon the foundation laid in "Module 4: Python Object-Oriented Programming (OOP)." The object-oriented structure and classes you developed in that module will serve as the core framework for the Library Management System. You will leverage the classes such as Book, User, Author that you previously designed, extending their capabilities to integrate seamlessly with the MySQL database.

Enhanced User Interface (UI) and Menu:

Create an improved, user-friendly command-line interface (CLI) for the Library Management System with separate menus for each class of the system. <div class="oc-markdown-custom-container oc-markdown-activatable" contenteditable="false" data-value="``` Welcome to the Library Management System with Database Integration!

Main Menu:
1. Book Operations
2. User Operations
3. Author Operations
4. Quit ```
5. Book Operations: <div class="oc-markdown-custom-container oc-markdown-activatable" contenteditable="false" data-value="``` Book Operations:
  1. Add a new book
  2. Borrow a book
  3. Return a book
  4. Search for a book
  5. Display all books "> Book Operations:
  6. Add a new book
  7. Borrow a book
  8. Return a book
  9. Search for a book
  10. Display all books ```
6. User Operations: <div class="oc-markdown-custom-container oc-markdown-activatable" contenteditable="false" data-value="``` User Operations:
  1. Add a new user
  2. View user details
  3. Display all users "> User Operations:
  4. Add a new user
  5. View user details
  6. Display all users ```
7. Author Operations: <div class="oc-markdown-custom-container oc-markdown-activatable" contenteditable="false" data-value="``` Author Operations:
  1. Add a new author
  2. View author details
  3. Display all authors "> Author Operations:
  4. Add a new author
  5. View author details
  6. Display all authors ```

Database Integration with MySQL:

Integrate a MySQL database into the Library Management System to store and retrieve data related to books, users, authors
Design and create the necessary database tables to represent these entities. You will align these tables with the object-oriented structure from the previous project.
Establish connections between Python and the MySQL database for data manipulation, enhancing the persistence and scalability of your Library Management System.

Data Definition Language Scripts:

Create the necessary database tables for the Library Management System. For instance:

Books Table:

Database Connection:

Establish a connection to the MySQL database using the mysql-connector-python library.
Create a database cursor to execute SQL queries. Functions for Data Manipulation:
Create functions for adding new books, users, authors to the database.
Implement functions for updating book availability, marking books as borrowed or returned.
Develop functions for searching books by book_id, title
Define functions for displaying lists of books, users, authors
Implement functions for user registration and viewing user details. User Interface Functions:
Create a user-friendly command-line interface (CLI) with clear menu options.
Implement functions to handle user interactions using the input() function.
Validate user input using regular expressions (regex) to ensure proper formatting. Error Handling:
Use try, except, else, and finally blocks to manage errors gracefully.
Handle exceptions related to database operations, input validation, and other potential issues.
Provide informative error messages to guide users. Clean Code Principles:
Use meaningful variable and function names that convey their purpose.
Write clear comments and docstrings to explain the functionality of functions and classes.
Follow PEP 8 style guidelines for code formatting and structure.
Ensure proper indentation and spacing for readability. Modular Design:
Organize code into separate modules to promote modularity and maintainability.
Create distinct modules for database operations, user interactions, error handling, and core functionalities. GitHub Repository:
Create a GitHub repository for your project and commit code regularly.
Maintain a clean and interactive README.md file in your GitHub repository, providing clear instructions on how to run the application and explanations of its features.
Include a link to your GitHub repository in your project documentation. Optional Bonus Points:
User Authentication (Bonus): Implement a user authentication system that requires users to create accounts and log in before accessing the library. This enhances security and allows for personalized features.
Due Dates for Borrowed Books (Bonus): Enhance the system by assigning due dates to borrowed books. When users borrow a book, the system should calculate and display the due date.
Fine Calculation (Bonus): Implement a fine calculation system for overdue books. Users who exceed the due date should be charged fines based on predefined rules. Users should have the option to pay fines, and their accounts should be updated accordingly. Effective Project Communication:
Demonstrate the ability to explain technical concepts and project details in a concise and understandable manner.

Project Tips

Reuse Your OOP Project: Take advantage of the object-oriented structure and classes you developed in "Module 4: Python Object-Oriented Programming (OOP)." This will save you time and effort by providing a solid foundation for integrating the database functionality.
Iterative Development: Start by designing a class hierarchy that represents the library's structure and entities. Test your code iteratively as you implement each feature to identify and address any potential bugs or issues.
Collaborate and Seek Assistance: Don't hesitate to collaborate with peers and seek assistance when needed. Learning is a collaborative effort, and discussing challenges with fellow learners can lead to valuable insights and solutions.
Modular Design: Emphasize modular design to keep your code organized and maintainable. Create separate modules for database operations, user interactions, error handling, and core functionalities.
Clean Code Practices: Follow clean code practices by using meaningful variable and function names, providing clear comments and docstrings, adhering to PEP 8 style guidelines, and ensuring proper code formatting and structure.
GitHub Repository: Create a GitHub repository for your project and commit code regularly. A version control system like Git will help you track changes and collaborate effectively.
Interactive README: Maintain an interactive README.md file in your GitHub repository. Provide clear instructions on how to run the application, explanations of its features, and include a link to your GitHub repository in your project documentation.
Optional Features: Consider implementing optional features such as user authentication, due dates for borrowed books, or fine calculation. These can add depth to your project and demonstrate your ability to adapt to varying requirements.

Remember that this project is an opportunity to showcase your skills, problem-solving abilities, and your understanding of database integration with Python. Enjoy the process, and don't hesitate to ask for help or clarification if needed. Happy coding! 📚🔍🖥️

Conclusion

The Library Management System with Database Integration project is your chance to combine the power of Python, object-oriented programming principles, and database integration to create a sophisticated solution for managing books and resources. By reusing the clean code and functions from your OOP project, you'll streamline development and maintain consistency.

Throughout this journey, remember to collaborate with your peers, follow clean code practices, and embrace modularity. Utilize Git and GitHub for version control, maintain an interactive README, and consider adding optional features like user authentication, due dates for borrowed books, or fine calculation to enhance your project.

With these tips in mind, embark on this coding adventure, and enjoy the process of creating a valuable Library Management System. Happy coding! 📚🔍🖥️

Module 5: Mini-project | Library Management System with Database Integration