PET SHOP MANAGEMENT SYSTEM

SESSION: 2024-25

A Project Report on

PET SHOP MANAGEMENT SYSTEM

For CBSE 2025 Examination

[As a part of the Computer Science Course (083)]

SUBMITTED BY : RAMESWAR BEHERA

CLASS : XII - A
ROLL NO : 27

SUBMITTED TO : Mr. S. K. MISRA

PGT (Computer Science)
CERTIFICATE
This is to certify that Rameswar Behera of Class XII-A has successfully completed the project
entitled ‘PET SHOP MANAGEMENT SYSTEM’ under the guidance of Mr. Saroj Kanta Misra
(PGT Computer Science) during the academic year 2024-25 in partial fulfillment of the
Computer Science Practical Examination of Central Board of Secondary Education (CBSE).

___________________________ ___________________________

Internal Examiner External Examiner

___________________________

Principal
ACKNOWLEDGEMENT
I would like to express my sincere gratitude to our Principal Mr. Shivapriya Dash for the
encouragement and support provided to carry out this project successfully. My heartfelt
thanks to my Computer Science teacher Mr. Saroj Kanta Misra for his constant guidance,
valuable suggestions, and motivation throughout the completion of this project. Lastly, I
would like to thank my classmates, friends, and family members for their help and
encouragement.

Name: Rameswar Behera

Class: XII-A
Sign: __________
TABLE OF CONTENTS
1. Introduction

2. Objectives of the Project

3. System Implementation

3.1 Hardware Used

3.2 Software Used

4. System Design & Development

4.1 Flow Chart

4.2 DFD Diagram

4.3 Python Coding

4.4 Database Design

4.5 Output Screens

5. Advantages of the System

6. Future Scope

7. References
1. INTRODUCTION
The Pet Shop Management System is a comprehensive and efficient software solution
designed to automate the operations of a pet store.

This project was developed using Python for its front-end logic and MySQL as its back-end
database, ensuring smooth and secure handling of all operations.

The system manages customers, pets, accessories, and orders, making it easy for both
customers and administrators to use.

Customers can register, log in, view products, place orders, and check their order history.

Administrators can manage stock, update inventory, add or delete records, and monitor
business activity.

This project demonstrates how real-world businesses can be modernized and digitized
through simple yet powerful software applications.
2. OBJECTIVES OF THE PROJECT
• To design and develop a user-friendly application for pet shop management.

• To maintain an efficient and secure record of customers and products.

• To automate tasks such as order placement, billing, and stock management.

• To provide real-time information about pet availability and accessories.

• To minimize paperwork and manual errors through database integration.

• To give administrators complete control over inventory and sales reports.

3. SYSTEM IMPLEMENTATION

3.1 Hardware Used

• Intel Core i3 Processor or above
• 4 GB RAM or more
• Hard Disk with 20 GB free space
• Monitor, Keyboard, Mouse

3.2 Software Used

• Operating System: Microsoft Windows 10
• Front End: Python IDLE
• Back End: MySQL Database
• Documentation: Microsoft Word 2010
4. SYSTEM DESIGN & DEVELOPMENT

4.1 Flow Chart

The following flow chart represents the working of the Pet Shop Management System. It
shows the sequence of operations starting from user login to order placement and
management.

START → LOGIN → MENU → (1) User Functions / (2) Admin Functions → Database
Operations → Display Output → END

4.2 Data Flow Diagram (DFD)

The Data Flow Diagram (DFD) illustrates the flow of information between processes in the
system. It helps to understand how data moves from one module to another within the
application.

Customer → Login → Pet Database → Order → Payment → Confirmation

4.3 Python Coding
The application has been developed using Python. The code includes functions for login,
registration, order management, and administrative tasks. The program connects to a
MySQL database to store data securely.

import [Link]
mydb = [Link](host='localhost', user='root', password='admin',
database='pet_management')
cb = [Link]()
[Link]('CREATE TABLE IF NOT EXISTS customers ( ... )')
[Link]('CREATE TABLE IF NOT EXISTS pets ( ... )')
[Link]()

import [Link]
mydb = [Link](host='localhost', user='root', password='admin',
database='pet_management')
cb = [Link]()
[Link]('CREATE TABLE IF NOT EXISTS customers ( ... )')
[Link]('CREATE TABLE IF NOT EXISTS pets ( ... )')
[Link]()

import [Link]
mydb = [Link](host='localhost', user='root', password='admin',
database='pet_management')
cb = [Link]()
[Link]('CREATE TABLE IF NOT EXISTS customers ( ... )')
[Link]('CREATE TABLE IF NOT EXISTS pets ( ... )')
[Link]()

import [Link]
mydb = [Link](host='localhost', user='root', password='admin',
database='pet_management')
cb = [Link]()
[Link]('CREATE TABLE IF NOT EXISTS customers ( ... )')
[Link]('CREATE TABLE IF NOT EXISTS pets ( ... )')
[Link]()

import [Link]
mydb = [Link](host='localhost', user='root', password='admin',
database='pet_management')
cb = [Link]()
[Link]('CREATE TABLE IF NOT EXISTS customers ( ... )')
[Link]('CREATE TABLE IF NOT EXISTS pets ( ... )')
[Link]()
4.4 Database Design
The database has been designed with normalization to ensure data consistency and
reliability. It includes the following tables:

• CUSTOMERS TABLE – stores user details such as ID, name, address, username, and
password.

• PETS TABLE – stores information about pets such as ID, type, breed, age, gender, price,
and quantity.

• PET ACCESSORIES TABLE – stores accessories with name, type, price, and quantity.

• USER ORDERS TABLE – stores customer orders, order date, and total amount.

Primary keys and foreign keys are used to ensure relational integrity between tables. The
database design allows easy modification and retrieval of records.
4.5 Output Screens
The system is text-based and user-friendly. The following are sample outputs generated
during program execution:

• WELCOME SCREEN

• USER SIGNUP AND LOGIN

• VIEW PETS AND ACCESSORIES

• PLACE ORDER

• ADMIN LOGIN AND CONTROL PANEL

========================================
WELCOME TO PET MANAGEMENT SYSTEM
========================================
Choose an option:
1. Sign up as User
2. Sign up as Admin
3. Exit

========================================
WELCOME TO PET MANAGEMENT SYSTEM
========================================
Choose an option:
1. Sign up as User
2. Sign up as Admin
3. Exit

========================================
WELCOME TO PET MANAGEMENT SYSTEM
========================================
Choose an option:
1. Sign up as User
2. Sign up as Admin
3. Exit

========================================
WELCOME TO PET MANAGEMENT SYSTEM
========================================
Choose an option:
1. Sign up as User
2. Sign up as Admin
3. Exit
========================================
WELCOME TO PET MANAGEMENT SYSTEM
========================================
Choose an option:
1. Sign up as User
2. Sign up as Admin
3. Exit
5. ADVANTAGES OF THE SYSTEM
• Provides quick access to customer and product information.

• Reduces manual work and paperwork.

• Ensures accurate record keeping.

• Improves customer experience through efficient service.

• Facilitates easy updating of stock and order tracking.

• Secure storage of sensitive customer and order data.

6. FUTURE SCOPE
• The system can be upgraded to include online payment integration.

• A mobile application version can be developed for easy access.

• Features like delivery tracking and customer feedback can be added.

• Graphical UI can be implemented using Python libraries like Tkinter or Django web
framework.

• Integration with third-party APIs for better stock management and reporting.
7. REFERENCES
• Python Documentation – [Link]
• MySQL Documentation – [Link]
• CBSE Computer Science Curriculum Guidelines
• W3Schools Python and MySQL Tutorials – [Link]