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.