software: mysql workbench (https://dev.mysql.com/downloads/mysql/)

mysql server login username: root

mysql server login username: user own password

database name: library_management

number of tables: 7

idauthor int(11) AI PK 

author_name varchar(45)

id int(11) AI PK 

book_name varchar(45) 

book_description varchar(45)

book_code varchar(45) 

book_category varchar(45)

book_author varchar(45)

book_publisher varchar(45)

book_price int(11)

idcategory int(11) AI PK 
category_name varchar(45)

idclient int(11) AI PK 
clientName varchar(45) 
clientEmail varchar(45) 
clientNid varchar(45)

iddayoperations int(11) AI PK 
bookname varchar(45) 
type varchar(30) 
days int(11) 
fromDate datetime 
toDate datetime 
clientName varchar(45)

idpublisher int(11) AI PK 
publisher_name varchar(45)

id_users int(11) AI PK 
username varchar(45) 
useremail varchar(45) 
userspassword varchar(45)

pip install mysqlclient

pip install MySQLdb 

pip install pyqt5ac  (to convert .qrc file to .py)

for conda : app.ipynb
for python: app.py

every time for the change of app_design.ui have to run the "convert_qrc_to_py.ipynb"(for conda), move the "icons_rc.py" to root folder from "generated folder" & then run the app.ipynb.