ACADMIC YEAR: 2024-25

PROJECT REPORT ON
FOOD PORTAL

Submitted by:
Aditya Singh
XII-B
Computer Science (083)

Project Guide:
Mr. Lalit Bhardwaj

C.B.S.E Roll Number :

 D.A.V. PUBLIC SCHOOL, KAILASH HILLS

CERTIFICATE

This is to certify that Raushan P.Yadav, student of class XII-B, has successfully
completed the research on the below mentioned project under the guidance of Mr. Lalit
Bhardwaj (Computer Science Teacher) during the year 2024-25 in partial fulfilment of
Computer Science.
Practical Examination conducted by AISSCE, New Delhi

Signature
 Table of Content

S. No. Description Page No.

1. Acknowledgement 4
2. Introduction Food Portal 5
3. Introduction to Python and My SQL
4. Software and other Requirements 7
5. Food Portal and Source Code 8
7. Output Screen 31
8. Bibliography 37
 Acknowledgement

Apart from the efforts of me, the success of any project depends largely on the encouragement and
guidelines of many others. I take this opportunity to express my gratitude to the people who have been
instrumental in the successful completion of this project.

I express deep sense of gratitude to almighty God for giving me strength for the successful completion of
the project. I express my heartfelt gratitude to my parents for constant encouragement while carrying out
this project.

I gratefully acknowledge the contribution of the individuals who contributed in bringing this project up to
this level, who continues to look after me despite my flaws.

I express my deep sense of gratitude towards Mrs. Ira Khanna, The Principal, D.A.V. Public School
Kailash Hills, for constant encouragement and the guidance provided during this project.

I am overwhelmed to express my thanks to the Computer Science Department for providing me an

infrastructure and moral support while carrying out this project in the school.

My sincere thanks to Mr. Lalit Bhardwaj, a guide, a Mentor and all the above a friend, who critically
reviewed my project and helped in solving each and every problem, occurred during implementation of
the project.

The guidance and support received from 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.
 Introduction to food portal

Abstract:
The Food Portal System is a Python-based application designed for managing food service operations,
integrated with a MySQL database. It provides a comprehensive platform for both customers and
administrators. Customers can register, log in, browse the food menu, place orders, and receive detailed
bills, including item prices and total amounts. The payment method can be selected as cash or card.

Administrators can manage various aspects of the business, such as customer details, staff management,
food menu updates, and salary management. Through the customer management module, administrators
can view and add new customers, while the staff management module allows adding, updating, and
removing staff, along with modifying their salaries. The system also enables food menu management,
including adding, removing, and updating food items.

The application provides all data in an easy-to-read tabular format, simplifying the display of staff,
customers, and food details. It also allows for salary updates and offers the option to modify the salary of
multiple staff members.

This system improves business efficiency by automating core processes like ordering, billing, and
employee management. By integrating these operations into a single interface, it enhances user experience
and ensures smooth business workflows. The system's functionality ensures streamlined management of
both customer and staff interactions, helping businesses improve performance and customer satisfaction.

User management system

The User Management System in the Food Portal application is designed to handle customer registration
and authentication processes. It ensures that users can securely register, log in, and manage their profiles.
This system helps differentiate between registered users and new visitors, allowing only authorized users
to access specific functionalities such as placing food orders.
Key Features:

1. Registration:

o Users can create an account by providing a unique username and password.

o The system checks if the username already exists in the database, preventing duplicates.
If the username is available, it stores the new user's credentials in the database for future
logins.

2. Login:

o Users can log in by entering their username and password.

o The system authenticates the entered credentials by verifying them against the stored data
in the database.

o If the credentials are correct, the user gains access to the system, enabling them to place
food orders, manage personal details, or perform other actions.

3. Security:

o The password is stored in the database, but in a real-world application, it would be

recommended to hash and salt the password for better security.

4. User Experience:

o The system allows users to interact with the platform by providing a seamless registration
and login experience, helping businesses keep track of customers for personalized
services, order history, and secure payment methods.

The User Management System enhances overall security and user experience, ensuring that only
registered customers can perform actions within the system, such as food ordering and viewing personal
data.

Customer management system

Customer Management in the Food Portal system plays a crucial role in organizing and managing
customer-related operations, providing an efficient way to interact with the platform’s users. This feature
enables the business to handle customer data, track orders, and manage interactions seamlessly, ensuring
a personalized and smooth experience for every user.
Key Features of Customer Management:

1. Customer Registration:

o New customers can easily be added to the system by providing their details such as name
and contact information.

o This data is stored securely in the database, enabling businesses to keep a record of all
customers.

2. Viewing Customer Information:

o The system allows staff or administrators to view a list of all registered customers.

o A tabular format is used to display customer details, such as customer ID, name, and
contact information, making it easy to manage large volumes of data.

3. Order Management:

o Through the Customer Management section, businesses can track the orders placed by
customers. This ties into the food ordering and bill generation system, allowing the staff
to manage customer orders efficiently.

o This also enables businesses to provide better service by recognizing repeat customers,
which can be helpful for loyalty programs or personalized recommendations.

4. Enhanced Customer Interaction:

o This feature ensures that customer queries, feedback, and preferences can be effectively
managed, promoting customer satisfaction.

5. Integration with Other Systems:

o The Customer Management system is integrated with billing and food order systems to
streamline the customer experience, allowing the staff to generate bills, track orders, and
ensure accurate service delivery.

In essence, Customer Management is vital for maintaining smooth operations, improving customer
relationships, and offering a customized experience in a food portal system.
1. Staff Management

The Staff Management component of the Food Portal system is responsible for handling all operations
related to managing staff members. This includes viewing, adding, removing, and updating staff
information such as their role, salary, and name. The system ensures that the management of staff is
organized and efficient by displaying all relevant data in a structured format.

Key Features and Operations:

• View Staff: Administrators can view a list of all staff members along with important details such
as their names, roles, and salaries. This is presented in a tabular format where each column adjusts
according to the longest data entry, ensuring that the information is easily readable. The system
fetches this data from the database and displays it in an organized manner.

• Add Staff: The system allows the addition of new staff members by entering their name, role, and
salary. Once the new data is submitted, it is stored in the database, and the staff member is added
to the staff list. This feature is crucial for maintaining an up-to-date staff roster.

• Remove Staff: If a staff member is no longer employed or needs to be removed for any other
reason, administrators can delete their record from the database. This action is performed by
entering the staff member's ID, and once confirmed, their data is removed permanently from the
system.

• Update Staff Details: Staff members' details (name, role, salary) can be updated. This is
particularly useful in cases such as role changes, salary adjustments, or personal information
corrections. The system prompts the administrator for the staff ID and allows them to input the
new details.

2. Food Management

Food Management is a critical part of the system, responsible for keeping the food menu updated and
managing the inventory of food items available for customers. This component allows for adding new
food items to the menu, removing discontinued items, and updating existing entries.

Key Features and Operations:

• View Food Menu: The system allows administrators to view the current food menu, including the
names of food items and their respective prices. The menu is displayed in a structured tabular
format, where each item’s ID, name, and price are clearly visible. The columns are automatically
adjusted to ensure proper alignment of data, making it easy to read.
 • Add Food Item: New food items can be added to the menu by entering the food name and price.
This operation involves inserting the new item’s details into the food menu database. Once the item
is added, it becomes available for customer selection when placing an order.

• Remove Food Item: When food items are no longer available or need to be removed (e.g., due to
changes in the menu or stock shortages), administrators can delete them from the system by
entering the food item’s ID. This ensures the menu remains up-to-date with only the current
offerings.

• Update Food Item: This function allows for modifications to existing food items, such as price
changes or renaming the item. Administrators can enter the food ID and update the name or price,
and the system will reflect these changes in the menu for all future customer orders.

3. Salary Management

Salary Management allows administrators to view, update, and maintain salary records for all staff
members. This feature is particularly important for managing payroll, ensuring accuracy, and adjusting
staff compensation as needed.

Key Features and Operations:

• View Salaries: The system presents the staff members’ salary details in a tabular format along
with their names and roles. This provides administrators with a quick overview of salary
distribution across the staff. It also ensures that salary-related records are stored accurately and can
be referenced at any time.

• Update Salary: The system allows administrators to update the salary of any staff member. This
is essential for processes like salary increments, bonus adjustments, or other changes in
compensation. To update a salary, the administrator selects the staff member’s ID, enters the new
salary amount, and confirms the change. Once updated, the new salary is reflected in the database.

• Multiple Updates: The system allows administrators to update salaries for multiple staff members.
After updating one salary, the system prompts whether they want to continue updating salaries for
other staff members, making the process more efficient. If the administrator wishes to stop
updating, they can simply exit the prompt.
4. Bill Generation

Bill Generation is a central feature for the Food Portal, enabling administrators or customers to create and
manage bills for food orders. This system ensures that the ordering process is clear and organized, allowing
customers to view the prices of items they wish to order and calculate the total cost.

Key Features and Operations:

• Food Selection: Customers or administrators can view the food items available for purchase, each
with its ID, name, and price. The food items are displayed in a table format for easy navigation,
where the customer can choose the items they wish to order.

• Order Creation: Once the food items are selected, the system prompts the user to input the
quantity for each item. After entering the quantity, the selected food item is added to the order list.
The system allows multiple items to be added, and the customer can continue selecting items until
they are ready to proceed with payment.

• Bill Generation: After all the items are selected, the system generates a detailed bill. The bill
includes each food item’s ID, name, price, quantity, and the total price for that item (price
multiplied by quantity). The total amount due is calculated by summing the prices of all items in
the order.

• Payment Method: After reviewing the bill, the system prompts the user to select a payment
method (either cash or card). Once the payment method is selected, the system records the payment
details and marks the transaction as complete, allowing the customer to finalize their order.

• Display of Bill: The system presents the bill in a structured table format, similar to the food menu,
with clear columns for each piece of information (item ID, name, price, quantity, and total). It also
calculates the overall total amount due, ensuring clarity for the customer.

This feature is critical in ensuring the accuracy of customer orders and facilitating smooth transactions
 Introduction to Python and My SQL

Python:
Python is an interpreted, high level, general-purpose high-level programming language. Python's design
philosophy emphasizes code readability with its notable use of significant whitespace. Its language
constructs and object-oriented approach aim to help programmers write clear, logical code for small and
large-scale projects.

Python is dynamically typed and it supports multiple object oriented, and functional programming

The python language is one of the most accessible programming languages available because it has
simplified syntax and not complicated, which gives more emphasis on natural language. Due to its ease of
learning and usage, python codes can be easily written and executed much faster than other programming
languages.

My SQL:
MySQL is an open source Relational Database Management System (RDBMS. A relational
database organizes data into one or more data tables in which data types may be related to each other;
these relations help structure the data. SQL is a language that programmers use to create, modify and
extract data from the relational database, as well as control user access to the database. In addition to
relational databases and SQL, an RDBMS like MySQL works with an operating system to implement a
relational database in a computer's storage system, manages users, allows for network access and
facilitates testing database integrity and creation of backups.
.

Software and other Requirements

• Operating System: Windows 7 or any other equivalent or higher.

• Python 3.x or higher and My SQL Server Version 5.x or higher.
• RAM- At least 1GB.
Processor: Pentium(any) or higher.