A python console application that mimics the operations of a library's database.The database consists of two tables 'Books' and 'Members.' The application interacts with the user and performs various CRUD operations.The DBMS used here is MySQL 8.0.The schema for the database can be found above.
You can test the application by following the below steps:
- Run the 'books_create' and 'members_create' files on MySQL.
- Install python and run the script 'main.py'.
Some of the operations that can be performed are:
- Add new books/ remove books.
- Add new user/ remove user.
- Lend a book/ return a book.
- Search database for a particular book.