This is to certify that SURAJ BABRIWAL of class: XII A of PM SHRI
Kendriya Vidyalaya IIT Indore has done his project on (Project title)
under my supervision. He has taken interest and has shown at most
sincerity in completion of this project.
I certify this Project up to my expectation & as per guidelines issued by
CBSE, NEW DELHI for AISSCE 2023.
Internal Examiner External Examiner
Examiner code: ………… Examiner code:……….
Principal
School code: 54259
It is with pleasure that I acknowledge my sincere gratitude to our
teacher, MR. Deepak Bhinde, PGT Computer Science who taught and
undertook the responsibility of teaching the subject computer science. I
have been greatly benefited from his classes.
I am especially indebted to our Principal Mrs. Neelam Malviya who has
always been a source of encouragement and support and without whose
inspiration this project would not have been a successful I would like to
place on record heartfelt thanks to him.
I am also thanks to my Team member JATIN PATEL for completion of
Project.
Finally, I would like to express my sincere appreciation for all the other
students for my batch their friendship & the fine times that we all shared
together.
With regards
(SURAJ BABRIWAL)
Roll no.1217
Hardware Requirement
o Laptop / Desktop
o Intel(R) Core(TM) i3-2400 CPU @ 3.10GHz or later version
o RAM :Minimum 2GB
o HDD : 80 GB
o Keyboard & Mouse
Software Requirement
o Operating System :Window 10
o Python 3.8 or later version
o MySQL Server 5.1.35 / CSV / Note Pad
o MySQL connector must be installed along with MySQL and
Python.
o Report : Microsoft word (MS Office)
S.No. Topic/ Contain Page No.
1. Introduction/Overview
2. Front end -Python Library/Module/Function
3. Backend –MySQL
4. Coding
5. Screen Shot
6. Feature of Project
7. Feedback
8. Conclusion
9. Reference
10.
11.
12.
Introduction/Overview.
The bookstore management system is an essential tool for
managing a bookstore’s inventory. It helps in keeping track of the
books available, customers, sales, and employees. The system also
helps in maintaining the details of the books given on rent, sales
record, employee’s details, and many other details.
The bookstore management system will help in maintaining the
details of the books available, customers details, details of the
books given on rent, sales record, employee’s details and many
other details can be mentioned in this application .
One example of a bookstore management system is a Python
project that uses MySQL connectivity to manage a book store . This
project includes features such as creating, adding, deleting,
searching, selling, and selling books, as well as staff and customer
details. The source code for this project is available online.
Front end -Python Library/Module/Function.
The project uses the following Python modules:
mysql.connector: A Python driver for MySQL databases that enables
Python programs to access MySQL databases
datetime: A module that supplies classes for working with dates and
times .
os: A module that provides a way of using operating system dependent
functionality like reading or writing to the file system .
time: A module that provides various time-related functions
Backend –MySQL.
MySQL databases, such as mysql-connector-
python, PyMySQL, and mysqlclient. These modules can be
used to connect to a MySQL database, execute queries, and retrieve
results .
Coding.
Screen Shots Of The Output Terminal.
Feature of Project.
A Python project that uses MySQL connectivity to manage a book store
is a good example of a bookstore management system. The project includes
features such as creating, adding, deleting, searching, selling, and selling
books, as well as staff and customer details. The source code for this project
is available online.
Here are some of the features of this project:
Adding books: The system allows you to add new books to the inventory
by providing details such as book name, author, publisher, and price.
Deleting books: The system allows you to delete books from the inventory
by providing the book ID.
Searching books: The system allows you to search for books in the
inventory by providing the book ID or book name.
Selling books: The system allows you to sell books to customers by
providing the book ID and customer details.
Viewing books: The system allows you to view all the books in the
inventory.
Staff management: The system allows you to manage staff details such as
name, address, and contact information.
Customer management: The system allows you to manage customer
details such as name, address, and contact information.
Feedback.
One such system is a SQL-based book management system that
uses SQLite3 and has an integrated graphical user interface . This
system allows users to make a list of books with the names of their
authors and the year they were published, and then keep that list as
a record. The system includes features such as adding, deleting,
searching, and modifying books, as well as displaying the books
available. The source code for this project is available online.
Another example is the Book Store Management System in Python .
This desktop application lets users make a list of books with the
names of their authors and the year they were published, and then
keep that list as a record. The system includes features such as
adding, deleting, and searching books, as well as displaying the
books available. The source code for this project is also available
online.
Conclusion.
A Book Shop Management System Project about the features of this
system, the user can make a list of books with their au thors, and year, and
keep them as records.
You just have to type the book information in the text fields and click on the
add button to add the information to the record.
This Book Store Management System In Python also includes a
downloadable Source Code for FREE, just find the downloadable source code
below and click to start downloading.
To start creating a Book Store Management System Python Project , make
sure that you have python Idle and Mysql installed on your computer.
The Book Store Management System Python is written in Python
programming language, Python is very easy to research the syntax
emphasizes readability and it is able to reduce time ingesting in developing.
Also, this tutorial is the simplest way for beginners or students to enhance
their logical skills in programming. and also in this System project is the way
for the students or beginners to design and develop the systems.
