This project is a Book Management System developed to enhance my skills as a software engineer. The system is designed to manage a collection of books, allowing users to add, update, delete, and search for books in a SQL relational database. The software integrates with a MySQL database using the mysql.connector library in Python.
The purpose of this software is to provide a practical application of database management and Python programming, demonstrating how to interact with a relational database through a Python application.
Software Demo Video: This is an external link to the video
The relational database used in this project is MySQL. The database consists of the following table:
- Books: Contains information about each book, including title, author, genre, and publication year.
The development environment for this project includes:
- Programming Language: Python 3
- Database: MySQL
- Libraries:
mysql.connectorfor database connectivity - Tools: MySQL Workbench for database management
Here are some websites that were helpful during the development of this project:
There are several areas for future improvement and additional features:
- Add a feature to export book data to CSV or Excel (in progress).
- Connect to a remote database and display the books to a website (in progress)
- Create the options to edit information about the book.
- Create a user interface for better usability.