VELAMMAL VIDYALAYA

ALAPAKKAM

Academic Session : 2022-23

SUBJECT : COMPUTER SCIENCE

SUBMITTED BY:
NAME OF THE STUDENT :KAVIYA.P
CLASS & SEC : XII-D
EXAM NO :
SUBMITTED TO TEACHER NAME: [Link]

TOPIC : PASTRY SHOP MANAGEMENT SYSTEM

1
 VELAMMAL EDUCATIONAL TRUST

VELAMMAL VIDYALAYA, ALAPAKKAM

Name : Batch No :

Class : Regd. No :

Certificate
Certified that this is a bonafide Record of Practical work done by
Mr/[Link] the
Laboratory during the year_

Teacher – In- Charge

MR. PRAVEEN

Submitted for the Practical Examination in _ at

held on

Principal Internal Examiners External Examiner

2
 ACKNOWLEDGEMENT

In the accomplishment of this project successfully, many people

have bestowed their blessings and heart pledged support upon me, I
take this opportunity to express my gratitude to all, who have been
instrumental in the successful completion of this project.

Primarily, I express my deep sense of gratitude to the luminary.

The Correspondent, Shri. M. V. M. VEL MOHAN, The Management
Coordinator Ms. TRISHNNA, The Principal. Dr. Y HEMALATHA, Senior
Head Master Dr. R SRIDHAR. for providing the best of facilities and
environment to bring out innovation and spirit of inquiry through this
venture.

I am deeply indebted to my teachers, without whose constructive

feedback, this project would not have been successful. The valuable
advice and suggestions for correction, modifications and improvement
did enhance the quality of the task.

I would also like to thank my parents, MR. PRAVEEN friends and

all the members who contributed to this project was vital for the success
of the project.

I am grateful for their constant support and help.

3
 CONTENTS

[Link] PARTICULARS PAGE NO

1 Introduction 5

2 Objectives of the Project 6

3 Feasibility of Study 7

4 Data Base For Maintaining 8

employee ,customer ,food and food order details
5 Source Code 10

6 Output 14

7 Tools and Technologies Used 22

8 Conclusion 23

9 Bibliography 24

4
 INTRODUCTION

The project Pastry Shop Management System gives idea about the
management in Pastry shops . It provides all the information about
purchasing details of the customer .The customer can make a order
his/her own food. It gives a detailed report about the product bought
by the customer.

The project will display the items details, cost and many more. I have
used Python software and MYSQL to enhance my project. The project
has much scope that it can be made more attractive and many more
modules can be attached to provide various services to the customers .
The main objective of the program is to give information about
Pastry Shop Management system.

5
 OBJECTIVES OF THE PROJECT

The following objectives are covered in this project :

 This project is used to give the details about the purchased items in a
easy way and to reduce time and increase user effectiveness.
 Inducing simplicity to ensure that people are easily understanding the
related technology and getting attracted.
 This project intends to introduce more user friendliness throughout the
project
 All the details about the payment are given properly in the database
and helps the customer and employee in the future.

6
 FEASIBILITY OF STUDY

The objective of feasibility study is to determine whether the

project system is feasible. The feasibility is determined in terms of three
aspects. These are: -
 Economic Feasibility
The Project is absolutely economical as it doesn’t really require
time to spend. It had the utmost concentration on making the project
more user friendly.

Thereby, it is made possible that anyone with a normal device with

Python and MYSQL in it can use it.

 Technical Feasibility
The Project must be technical feasible as to ensure that the
project is proceeding or not. It is taken utmost care use an ensuring
platform Python and MYSQL which is both developable and
technological.

As the technologies used are safe and user friendly, the project is
technically feasible

 Operational Feasibility
The project is checked to ensure that it is user friendly and the
software meets all the needs of a person to use, makes it a
operationally feasible one.

7
DATA BASE FOR MAINTAINING EMPLOYEE,[Link],FOOD
ORDER DETAILS
TABLE FOR STORING EMPLOYEE DETAILS :

TABLE FOR STORING CUSTOMER DETAILS :

TABLE FOR STORING FOOD ITEMS DETAILS:

TABLE FOR STORING FOOD ORDER DETAILS :

SOURCE CODE
OUTPUT
 TOOLS AND TECHNOLOGIES USED

Hardware Requirements
I. Operating System : Windows 7 and above
II. Processor : Any Processor
III. Ram : 4GB
IV. Hard dis : 300 MB and above
V. Monitor
VI. Keyboard and Mouse

Software Requirements
I. Windows OS
II. Python
III. MYSQL
IV. Notepad
 CONCLUSION
This project shall prove to be a powerful package in satisfying the requirements in pastry
shops. This ensures that the application does not crash or breakdown. Flexible for both
customer and dealer. The objective of this project is to provide a framework that enables
the manager to make resonable estimate made within limited time. I say that this project
has given me a great experience and I was personally benefited.
.
 BIBLIOGRAPHY

1) Computer Science with Python

2) Class XII Textbook by Sumita Arora

24