lOMoARcPSD|38739388

Final report dbms project

Dbms (SRM Institute of Science and Technology)

Scan to open on Studocu

Studocu is not sponsored or endorsed by any college or university

Downloaded by Jaisurya (mjaisurya10@gmail.com)
 lOMoARcPSD|38739388

FOOD DELIVERY
MANAGEMENT SYSTEM

Submitted by

SRIYA GURRAWAR[RA2111033010092]

Under the Guidance of

MS. SASI REKHA SANKAR

Assistant Professor, Department of Computational Intelligence

In partial satisfaction of the requirements for the degree of

BACHELORS OF TECHNOLOGY in
ARTIFICAL INTELLIGENCE

SCHOOL OF COMPUTING
COLLEGE OF ENGINEERING AND TECHNOLOGY
SRM INSTITUTE OF SCIENCE AND TECHNOLOGY
KATTANKULATHUR - 603203
May 2024

Downloaded by Jaisurya (mjaisurya10@gmail.com)

 lOMoARcPSD|38739388

SRM INSTITUTION OF SCIENCE AND TECHNOLOGY

KATTANKULATHUR-603203

BONAFIDE CERTIFICATE

Certified that this Course Project Report titled “FOOD DELIVERY MANAGEMENT” is the
bonafide work done by, SRIYA GURRAWAR(RA2111033010092), Sem B.TECH ,CSE
(SoftwareEngineering) who carried out under my supervision for the course 18CSC303J - Database
Management Systems for Computer Science Engineering. Certified further, that to the best of my
knowledge the work reported herein does not form part of any other work.

SIGNATURE HEAD OF THE DEPARTMENT

Faculty In-Charge Dr. R Annie Uthra
MS. SASI REKHA SANKAR Professor and Head ,
Assistant Professor Department of Computational
Department of Computational Intelligence Intelligence,
SRM Institute of Science and Technology SRM Institute of Science and
Kattankulathur Campus, Chennai Technology
Kattankulathur Campus, Chennai

ABSTRACT

Food delivery management is a crucial aspect of the food industry, which involves the
coordination of different activities such as order-taking, food preparation, packaging,
ii

Downloaded by Jaisurya (mjaisurya10@gmail.com)

 lOMoARcPSD|38739388

and delivery. In recent years, the demand for food delivery services has grown
significantly, and businesses are facing increasing pressure to provide efficient and
reliable delivery services. The aim of this paper is to review the existing literature on
food delivery management and to provide insights into the key factors that influence
the effectiveness of food delivery operations. The paper also discusses the challenges
faced by businesses in managing food delivery services and proposes strategies to
overcome these challenges. The findings of this study highlight the importance of
technology, customer service, and operational efficiency in food delivery management.
Overall, this paper provides a comprehensive overview of food delivery management
and serves as a valuable resource for businesses and researchers in the food industry.
Food delivery management plays a critical role in ensuring that customers receive their
food orders on time and in the desired condition. Effective management of food
delivery services requires businesses to have a well-structured process that involves the
coordination of different stakeholders, including restaurant staff, delivery drivers, and
customers. The use of technology, such as mobile applications and online platforms,
has become increasingly popular in recent years, and it has enabled businesses to
streamline their operations and provide better customer service.
TABLE OF CONTENTS
Chapter No Title PageNo.

ABSTRACT ii

TABLE OF CONTENTS iii

LIST OF FIGURES iv

LIST OF TABLES v

ABBREVIATIONS vi

1 INTRODUCTION 1
1.1 Introduction 1
1.2 Problem statement 2
1.3 Objectives 3
1.4 Scope and applications 4
1.5 General and Unique Services in the database application 5
iii

Downloaded by Jaisurya (mjaisurya10@gmail.com)

 lOMoARcPSD|38739388

1.6 Software Requirements Specification 6

1.7 Software tools used 9
2 LITERATURE
SURVEY
2.1 Existing issues
2.2 Comparison of Existing vs Proposed system
3 SYSTEM ARCHITECTURE ANDDESIGN 14
3.1 Architecture Diagram 14
3.1.1 Front end (UI)design 15
3.1.2 Back end (Database Table) design 16
3.2 ER Diagram and Use case Diagram 17
4 CODING AND TESTING 32
5 RESULTS AND DISCUSSION 33

6 CONCLUSION AND FUTURE ENHANCEMENT 34

7 REFERENCES 35

LIST OF FIGURES
FigureNo Figure Name PageNo
3.1. Er Diagram 14
3.2. Admin Login page 21
3.3. Admin Dashboard 22
3.4. Admin Upload Products Page 23
3.5. Admins Page 24
3.6. Admin Can see user’s login 25
3.7. User login page 26
3.8. User register page 27
3.9. User home page 28
3.10. Users can see the admin products 29
3.11. Users cart 30
3.12. Users logout or update profile 31

iv

Downloaded by Jaisurya (mjaisurya10@gmail.com)

 lOMoARcPSD|38739388

LIST OF TABLES

TableNo. TableName PageNo

4.1 ADMIN LOGIN TABLE 19 4.2

CART TABLE 19 4.3 ORDERS
TABLE 19 4.4 PRODUCTS TABLE
20 4.5 USERS TABLE 20

Downloaded by Jaisurya (mjaisurya10@gmail.com)

 lOMoARcPSD|38739388

ABBREVIATIONS

AES Advanced EncryptionStandard

ANN Artificial NeuralNetwork

CSS Cascading StyleSheet

CV ComputerVision
DB DataBase
DNA DeoxyriboNeucleicAcid
SQL Structured QueryLanguage
SVM Support VectorMachine
UI UserInterface

vi

Downloaded by Jaisurya (mjaisurya10@gmail.com)

 lOMoARcPSD|38739388

vii

Downloaded by Jaisurya (mjaisurya10@gmail.com)

 lOMoARcPSD|38739388

CHAPTER1

INTRODUCTION

1.1 FOOD DELIVERY

Food delivery management is a critical aspect of the food industry that involves the
coordination n number of activities such as order-taking, food preparation, packaging,
and delivery to ensure that customers receive their food orders on time and in good
condition. The growth of the food delivery market in recent years has led to an
increased demand for efficient and reliable delivery services, and businesses are under
pressure to provide a high-quality service to remain competitive.

Effective food delivery management requires businesses to have a well-structured

process that involves the coordination of different stakeholders, including restaurant
staff, delivery drivers, and customers. Technology has become increasingly important
in food delivery management, and businesses are using mobile applications and online
platforms to streamline their operations and provide better customer service.

However, food delivery management also poses several challenges that businesses must
overcome, such as managing food quality and safety during delivery, managing
delivery times and schedules, dealing with unforeseen circumstances such as traffic and
weather conditions, and ensuring the safety of delivery drivers.

This paper aims to review the existing literature on food delivery management and
provide insights into the key factors that influence the effectiveness of food delivery
operations. The paper also discusses the challenges faced by businesses in managing
food delivery services and proposes strategies to overcome these challenges. By
understanding the key factors and challenges involved in food delivery management,
businesses can optimize their operations and provide customers with a positive
experience.
1

Downloaded by Jaisurya (mjaisurya10@gmail.com)

 lOMoARcPSD|38739388

1.2. PROBLEM STATEMENT

There are several existing issues in the food delivery system that a food delivery
management system can address. Here are some of the most common ones:
Delayed Deliveries: One of the most common issues in food delivery is delayed
deliveries. This can happen due to various reasons such as traffic, weather conditions,
or a high volume of orders. Delayed deliveries can lead to unhappy customers and
negative reviews.
Inaccurate Orders: Another common issue is inaccurate orders. This can happen due to
miscommunication between the restaurant staff and delivery drivers or errors in the
order processing system. Inaccurate orders can lead to customer dissatisfaction and
potentially lost business.

Miscommunication: Miscommunication can happen at any point in the food delivery

process, whether it's between the restaurant staff and the delivery driver or between the
driver and the customer. Miscommunication can lead to incorrect orders, delayed
deliveries, and other issues that can impact customer satisfaction.

Limited Menu Options: Some food delivery services may have limited menu options,
which can be frustrating for customers who want a wider range of choices. This can
lead to lost business if customers choose to order from a competitor with a more
extensive menu.

High Delivery Fees: Some food delivery services may charge high delivery fees, which
can discourage customers from using the service or make it less cost-effective for them.
This can also lead to lost business if customers choose to order from a competitor with
lower delivery fees.

Downloaded by Jaisurya (mjaisurya10@gmail.com)

 lOMoARcPSD|38739388

1.3 OBJECTIVES
The objectives of food delivery management are to:
1. Ensure timely and accurate order processing: This involves the efficient handling of
orders, including timely order confirmation, tracking, and dispatch, to ensure that
orders are delivered on time and accurately.
2. Maintain high food quality and safety standards: This objective involves ensuring that
food is prepared, packaged, and transported in compliance with safety and quality
standards to maintain customer satisfaction and avoid potential health risks.
3. Optimize delivery logistics and route planning: Effective route planning and scheduling
can help businesses minimize delivery times and costs, reduce the number of delivery
vehicles required, and improve overall operational efficiency.
4. Enhance customer satisfaction and loyalty: This objective involves providing a positive
customer experience through the use of user-friendly online ordering platforms,
realtime order tracking, and effective communication with customers.
5. Improve operational efficiency: Businesses can use technology and data analytics to
optimize their operations and improve efficiency. This includes the use of automated
order processing systems, real-time route optimization, and delivery tracking systems
to improve delivery times and reduce costs.
By achieving these objectives, businesses can provide a high-quality food delivery
service, improve customer satisfaction and loyalty, and optimize their operations to
remain competitive in the food delivery market.

Downloaded by Jaisurya (mjaisurya10@gmail.com)

 lOMoARcPSD|38739388

1.4 SCOPE AND APPLICATIONS

a. The scope of food delivery management includes the coordination and management of
activities related to the delivery of food from restaurants to customers. This includes
order processing, food preparation and packaging, delivery scheduling and logistics,
and communication with customers and delivery drivers. The scope of food delivery
management also includes ensuring food quality and safety during transportation and
delivery.
b. The applications of food delivery management are widespread, and include:
1. Restaurants and food businesses: Restaurants and food businesses can use food
delivery management systems to offer their customers a convenient and efficient
delivery service, while maintaining high food quality and safety standards.
2. Delivery service providers: Third-party delivery service providers can use food
delivery management systems to manage their operations and provide an efficient and
reliable delivery service to restaurants and customers.
3. Logistics companies: Logistics companies can use food delivery management systems
to optimize their delivery routes and schedules, reduce costs, and improve operational
efficiency.
4. Food delivery aggregators: Food delivery aggregators can use food delivery
management systems to manage their online platforms and coordinate delivery services
across multiple restaurants and delivery service providers.
5. Government regulators: Government regulators can use food delivery management
systems to monitor and enforce food safety standards during the transportation and
delivery of food, to protect the health and safety of consumers.Overall, food delivery
management has a wide range of applications and can benefit businesses, delivery
service providers, logistics companies, and consumers by providing an efficient,
reliable, and safe food delivery service.

1.4 GENERAL AND UNIQUE SERVICES PROVIDEDBY DATABASE

MANAGEMENT
a. General services provided by a database application for food delivery management
include:

Downloaded by Jaisurya (mjaisurya10@gmail.com)

 lOMoARcPSD|38739388

1. Order Management: The database application should allow restaurants to receive and
manage customer orders. This includes tracking the status of orders, updating order
details, and generating reports.
2. Customer Management: The database application should allow restaurants to manage
their customer data, including customer preferences, contact information, and order
history.
3. Delivery Management: The database application should allow restaurants to manage
the delivery of their food, including delivery scheduling, route planning, and driver
management.
4. Inventory Management: The database application should allow restaurants to manage
their inventory of food items, including tracking stock levels, ordering supplies, and
managing waste.
5. Overall, a database application for food delivery management should provide a
comprehensive set of services to help restaurants manage their operations efficiently
and provide a high-quality food delivery service to their customer.

1.5 SOFTWARE REQIREMENT SPECIFICATION

Introduction:
The purpose of this Software Requirements Specification (SRS) document is to outline
the requirements for a food delivery management system. The system will be designed
to manage the order processing, food preparation, delivery scheduling, and customer
communication for restaurants and food delivery service providers.

Functional Requirements:

1. Order Management:
The system should allow restaurants to receive and manage customer orders.
The system should allow customers to place orders through a website or mobile
application.
The system should provide notifications to the restaurant when a new order is received.

2. Customer Management:
The system should allow restaurants to manage their customer data, including customer
preferences, contact information, and order history.
The system should provide customers with the ability to view their order history and
update their contact information.

Downloaded by Jaisurya (mjaisurya10@gmail.com)

 lOMoARcPSD|38739388

3. Delivery Management:
The system should allow restaurants to manage the delivery of their food, including
delivery scheduling, route planning, and driver management.
The system should provide real-time delivery tracking for customers.
The system should provide delivery drivers with a mobile application to manage their
deliveries.
4. Inventory Management:
The system should allow restaurants to manage their inventory of food items, including
tracking stock levels, ordering supplies, and managing waste.
5. Analytics and Reporting:
The system should provide insights and reports to help restaurants analyze their
performance, including sales data, customer feedback, and delivery times.

6.Non-functional Requirements:
1. Performance:
The system should be able to handle a high volume of orders and customers.
The system should provide fast response times to customers and restaurants.
2. Security:
The system should have a secure login system for restaurants and customers.
The system should encrypt sensitive data such as customer payment information.

3. Usability:
The system should be easy to use and navigate for both customers and restaurants. The
system should have a user-friendly interface for order management and delivery
scheduling.
4. Availability:
The system should have high availability to ensure that restaurants and customers can
access the system at all times.
The system should have a disaster recovery plan in case of system failures.

USER LOGIN:
Description of feature
This feature used by the admin to login into system. They are required to enter Admin
id and password before they are allowed to enter the system. The Admin id and password
will be verified and if invalid id is there Admin is allowed to not enter the system.

Downloaded by Jaisurya (mjaisurya10@gmail.com)

 lOMoARcPSD|38739388

Functional requirements
-Admin id is provided when they register
-The system must only allow Admin with valid id and password to enter the system -
The system performs authorization process which decides what Admin level can access
to.
-The Admin must be able to logout after they finished using system.

REGISTER NEW ADMIN:

Description of feature
This feature can be performed by all Admins to register new Admin to create account.

Functional requirement
-System must be able to verify information
-System must be able to delete information if information is wrong
USER LOGIN :
Description of feature
This feature used by the user to login into system. They are required to enter user id and
password before they are allowed to enter the system. The user id and password will be
verified and if invalid id is there user is allowed to not enter the system.

Functional requirements
-user id is provided when they register
-The system must only allow user with valid id and password to enter the system -The
system performs authorization process which decides what user level can acess to.
-The user must be able to logout after they finished using system.
REGISTER NEW USER:
Description of feature
This feature can be performed by all users to register new user to create account.
Functional requirements
-System must be able to verify information
-System must be able to delete information if information is wrong

Downloaded by Jaisurya (mjaisurya10@gmail.com)

 lOMoARcPSD|38739388

1.6 SOFTWARE TOOLS USED:

•HTML- HTML or Hyper Text Markup Language is the main markup language for
creating web pages and other information that can be displayed in a web browser.HTML
is written in the form of HTML elements consisting of tags enclosed in angle brackets
(like <html>), within the web page content. HTML tags most commonly come in pairs
like <h1> and </h1>, although some tags represent empty elements and so are unpaired,
for example <img>. The first tag in a pair is the start tag, and the second tag is the end
tag (they are also called opening tags and closing tags). In between these tags web
designers can add text, further tags, comments and other types of text-based content.
The purpose of a web browser is to read HTML documents and compose them into
visible or audible web pages. The browser does not display the HTML tags, but uses the
tags to interpret the content of the page.HTML elements form the building blocks of all
websites. HTML allows images and objects to be embedded and can be used to
create interactive forms. It provides a means to create structured
documents by denoting structural semantics for text such as headings, paragraphs, lists,
links, quotes and other items. It can embed scripts written in languages such as
JavaScript which affect the behavior of HTML web pages.

•CSS- Cascading Style Sheets (CSS) is a style sheet language used for describing the
look and formatting of a document written in a markup language. While most often used
to style web pages and interfaces written in HTML and XHTML, the language can be
applied to any kind
of XML document, including plain XML, SVG and XUL. CSS is a cornerstone
specification of the web and almost all web pages use CSS style sheets to describe their
presentation.CSS is designed primarily to enable the separation of document content
from document presentation, including elements such as the layout, colors, and fonts.
8

Downloaded by Jaisurya (mjaisurya10@gmail.com)

 lOMoARcPSD|38739388

This separation can improve content accessibility, provide more flexibility and control
in the specification of presentation characteristics, enable multiple pages to share
formatting, and reduce complexity and repetition in the structural content (such as by
allowing for table less web design).CSS can also allow the same markup page to be
presented in different styles for different rendering methods, such as on-screen, in print,
by voice (when read out by a speech-based browser or screen reader) and on
Braillebased, tactile devices. It can also be used to allow the web page to display
differently depending on the screen size or device on which it is being viewed. While
the author of a document typically links that document to a CSS file, readers can use a
different style sheet, perhaps one on their own computer, to override the one the author
has specified. However if the author or the reader did not link the document to a specific
style sheet the default style of the browser will be applied.CSS specifies a priority
scheme to determine which style rules apply if more than one rule matches against a
particular element. In this so-called cascade, priorities or weights are calculated and
assigned to rules, so that the results are predictable.

•JAVA SCRIPT- JavaScript (JS) is a dynamic computer programming language. It is

most commonly used as part of web browsers, whose implementations allow client-side
scripts to interact with the user, control the browser, communicate asynchronously, and
alter the document content that is displayed. It is also being used in server-side
programming, game development and the creation of desktop and mobile applications.
JavaScript is a prototype-based scripting language with dynamic typing and has first-
class functions. Its syntax was influenced by C. JavaScript copies many names and
naming conventions from Java, but the two languages are otherwise unrelated and have
very different semantics. The key design principles within JavaScript are taken from the
Self and Scheme programming languages. It is a multi- paradigm language, supporting
object-oriented, imperative,and functional programming styles. The application of
JavaScript to use outside of web pages—for example, in PDF documents, site-specific
browsers, and desktop widgets—is also significant. Newer and faster JavaScript VMs
and platforms built upon them (notably Node.js) have also increased the popularity of
JavaScript for server-side web applications. On the client side, JavaScript was
traditionally implemented asan interpreted language but just-in-time compilation is now
performed by recent (post-2012) browsers.
•PHP- PHP is a server-side scripting language designed for web development but also
used as a general-purpose programming language. PHP is now installed on more than
244 million websites and 2.1 million web servers. Originally created by Rasmus Lerdorf
in 1995, the reference implementation of PHP is now produced by The PHP Group.
While PHP originally stood for Personal Home Page, it now stands for PHP: Hypertext
Preprocessor, a recursive backronym. PHP code is interpreted by a web server with a
9

Downloaded by Jaisurya (mjaisurya10@gmail.com)

 lOMoARcPSD|38739388

PHP processor module, which generates the resulting web page: PHP commands can be
embedded directly into an HTML source document rather than calling an external file
to process data. It has also evolved to include a command-line interface capability and
can be used in standalone graphical applications. PHP is free software released under
the PHP License. PHP can be deployed on most web servers and also as a standalone
shell on almost every operating system and platform, free of charge.

BACK END - The back end is designed using mysql which is used to design the
databases
MYSQL- MySQL ("My S-Q-L", officially, but also called "My Sequel") is (as of
July 2013) the world's second most widely used open-source relational database
management system (RDBMS). It is named after co-founder Michael Widenius
daughter, My. The SQL phrase stands for Structured Query Language. The MySQL
development project has made its source code available under the terms of the GNU
General Public License, as well as under a varietyof proprietary agreements. MySQL
was owned and sponsored by a single for- profit firm, the Swedish company MySQL
AB, now owned by Oracle CorporationMySQL is a popular choice of database for use
in web applications, and is a central component of the widely used LAMP opensource
web application software stack (and other 'AMP' stacks). LAMP is an acronym for
"Linux, Apache, MySQL, Perl/PHP/Python." Free-software-open source projects that
require a full-featured database management system often use MySQL. For commercial
use, several paid editions are available, and offer additional functionality. Applications
which use MySQL databases

include:
TYPO3, MODx, Joomla, WordPress, phpBB,MyBB, Drupal and other software.
MySQL is also used in many high-profile, large-scale websites, including Wikipedia,
Google (though not for searches), Facebook, Twitter, Flickr, and YouTube.

10

Downloaded by Jaisurya (mjaisurya10@gmail.com)

 lOMoARcPSD|38739388

CHAPTER 2
SURVEY

2.1 Existing issues in food delivery system:

There are several existing issues in the food delivery system that a food delivery management
system can address. Here are some of the most common ones:
Delayed Deliveries: One of the most common issues in food delivery is delayed deliveries.
This can happen due to various reasons such as traffic, weather conditions, or a high volume
of orders. Delayed deliveries can lead to unhappy customers and negative reviews.
Inaccurate Orders: Another common issue is inaccurate orders. This can happen due to
miscommunication between the restaurant staff and delivery drivers or errors in the order
processing system. Inaccurate orders can lead to customer dissatisfaction and potentially lost
business.

Miscommunication: Miscommunication can happen at any point in the food delivery process,
whether it's between the restaurant staff and the delivery driver or between the driver and the
customer. Miscommunication can lead to incorrect orders, delayed deliveries, and other issues
that can impact customer satisfaction.

Limited Menu Options: Some food delivery services may have limited menu options, which
can be frustrating for customers who want a wider range of choices. This can lead to lost
business if customers choose to order from a competitor with a more extensive menu.

High Delivery Fees: Some food delivery services may charge high delivery fees, which can
discourage customers from using the service or make it less cost-effective for them. This can

11

Downloaded by Jaisurya (mjaisurya10@gmail.com)

 lOMoARcPSD|38739388

also lead to lost business if customers choose to order from a competitor with lower delivery
fees.

2.2 Existing vs proposed system:

Online Ordering: The existing system may have online ordering platforms, but they may not
be user-friendly or offer a wide range of menu options. The proposed system would have a
more user-friendly and efficient online ordering platform that would allow customers to
customize their orders and have access to a wider range of menu options.

Real-Time Tracking: The existing system may have some tracking features, but they may not
be in real-time or provide accurate delivery times. The proposed system would have a realtime
tracking system that would provide customers with more accurate delivery times and reduce
the risk of delayed deliveries.

Route Optimization: The existing system may not have a route optimization feature, which can
lead to delayed deliveries and longer delivery times. The proposed system would have a route
optimization feature that would allow drivers to plan the most efficient delivery routes,
reducing the risk of delayed deliveries and improving overall delivery times.

Inventory Management: The existing system may not have an inventory management system,
which can lead to shortages of popular items and delayed orders. The proposed system would
have an inventory management system that would allow restaurants to keep track of their
inventory levels in real-time and ensure that orders can be fulfilled quickly and accurately.

Communication System: The existing system may not have a communication system in place,
which can lead to miscommunication and inaccurate orders. The proposed system would have
a communication system that would allow restaurant staff and delivery drivers to communicate
in real-time, reducing the risk of miscommunication and ensuring that orders are accurate and
delivered on time.
12

Downloaded by Jaisurya (mjaisurya10@gmail.com)

 lOMoARcPSD|38739388

Quality Control: The existing system may not have a quality control system in place, which
can lead to poor quality food and customer complaints. The proposed system would have a
quality control system that would ensure that food is packaged properly and kept at the
appropriate temperature during transportation, reducing the risk of poor quality food and
customer complaints.

CHAPTER 3

SYSTEM ARCHITECTURE AND DESIGN

3.1 ARCHITECTURE

The architecture diagram for online delivery

13

Downloaded by Jaisurya (mjaisurya10@gmail.com)

 lOMoARcPSD|38739388

3.1.1 FRONTEND UI:

The frontend code for food delivery project.

14

Downloaded by Jaisurya (mjaisurya10@gmail.com)

 lOMoARcPSD|38739388

3.1.2 BACKEND UI:

The backend code for food delivery project

15

Downloaded by Jaisurya (mjaisurya10@gmail.com)

 lOMoARcPSD|38739388

3.2 ER DIAGRAM
An Entity-Relationship Diagram (ERD) is a graphical representation of entities and their
relationships to each other. Here is an ER diagram that explains the entities and
relationships in an online food delivery system:
16

Downloaded by Jaisurya (mjaisurya10@gmail.com)

 lOMoARcPSD|38739388

Entities:
• User: Represents a user who can browse, order and pay for food.
• Restaurant: Represents a restaurant that can accept orders from users and prepare
food.
• Menu: Represents the food items available for order at a restaurant.
• Order: Represents a user's order for food from a restaurant.
• Payment: Represents a user's payment for an order.
Relationships:
• A user can place multiple orders, but each order is placed by only one user.
• A restaurant can receive multiple orders, but each order is placed at only one
restaurant.
• A restaurant can have multiple food items on its menu, and each food item is
associated with only one restaurant.
• A user can pay for multiple orders, but each payment is made for only one order.
• An order can have only one payment.
• An order can have only one delivery, but a delivery can deliver multiple orders.
• A user can have multiple addresses, but each address is associated with only one
user.
• An order is associated with one delivery, and a delivery is associated with one
order.
The ER diagram provides an overview of the relationships between the entities in an
online food delivery system, which can help in designing the system and identifying
potential issues.

17

Downloaded by Jaisurya (mjaisurya10@gmail.com)

 lOMoARcPSD|38739388

3.1 ER DIAGRAM

18

Downloaded by Jaisurya (mjaisurya10@gmail.com)

 lOMoARcPSD|38739388

DATA BASE (SQL)TABLES

4.3 ADMIN LOGIN TABLE:

4.4 PRODUCTS TABLE:

4.5 ORDERS TABLE:

19

Downloaded by Jaisurya (mjaisurya10@gmail.com)

 lOMoARcPSD|38739388

4.1 USERS TABLES:

4.2 CART TABLE:

20

Downloaded by Jaisurya (mjaisurya10@gmail.com)

 lOMoARcPSD|38739388

ADMIN WEBPAGES
Admin Login page:

2
3.2 ADMIN LOGIN PAGE

21

Downloaded by Jaisurya (mjaisurya10@gmail.com)

 lOMoARcPSD|38739388

Admin Dashboard:

3.3 ADMIN DASHBOARD

22

Downloaded by Jaisurya (mjaisurya10@gmail.com)

 lOMoARcPSD|38739388

Admin Upload Products Page:

3.4 ADMIN UPLOAD PRODUCTS PAGE

23

Downloaded by Jaisurya (mjaisurya10@gmail.com)

 lOMoARcPSD|38739388

Admins Page:

3.5 ADMINS PAGE

24

Downloaded by Jaisurya (mjaisurya10@gmail.com)

 lOMoARcPSD|38739388

Admin Can see user’s login:

3.6 ADMIN CAN SEE USER LOGIN

25

Downloaded by Jaisurya (mjaisurya10@gmail.com)

 lOMoARcPSD|38739388

USERS PORTAL 1.
USER LOGIN PAGE:

3.7 USER LOGIN PAGE

2.USER REGISTER PAGE:

26

Downloaded by Jaisurya (mjaisurya10@gmail.com)

 lOMoARcPSD|38739388

3.8 USER REGISTRATION PAGE

27

Downloaded by Jaisurya (mjaisurya10@gmail.com)

 lOMoARcPSD|38739388

3.USER HOME PAGE:

3.9 USER HOME PAGE

4.USER CAN SEE THE ADMIN PRODUCTS:

28

Downloaded by Jaisurya (mjaisurya10@gmail.com)

 lOMoARcPSD|38739388

3.10 USERS CAN SEE ADMIN PORTAL

29

Downloaded by Jaisurya (mjaisurya10@gmail.com)

 lOMoARcPSD|38739388

USERS CART:

3.11 USERS CART

30

Downloaded by Jaisurya (mjaisurya10@gmail.com)

 lOMoARcPSD|38739388

User logout or update profile:

3.12 USERS LOGOUT OR UPDATE PROFILE

31

Downloaded by Jaisurya (mjaisurya10@gmail.com)

 lOMoARcPSD|38739388

CHAPTER 5 CODING AND TESTING

Developing a food delivery website involves a significant amount of coding and testing.
The coding must ensure that the website functions properly, is secure, compatible with
various devices and browsers, and performs well under high traffic. Testing is essential
to identify any issues and vulnerabilities in the website and ensure that it provides a
seamless user experience. Security is a critical aspect of website development, as it
involves handling sensitive customer data, such as payment information and order
history. The website's performance, responsiveness, and integration capabilities are
other essential factors that need to be addressed during the coding and testing phases.
The success of a food delivery website depends on its ability to provide a seamless user
experience, efficient order management, secure payment processing, and reliable
customer support. Coding and testing are essential to ensure that the website meets these
requirements and functions optimally. A well-coded website that is thoroughly tested for
security, compatibility, and performance can enhance customer satisfaction, increase
brand reputation, and drive business growth. By continuously improving and updating
the website, businesses can stay competitive in the ever-evolving food delivery industry
and meet the changing needs and expectations of their customers.

CHAPTER 6
RESULTS AND DISSCUSSIONS

32

Downloaded by Jaisurya (mjaisurya10@gmail.com)

 lOMoARcPSD|38739388

The food delivery project aims to improve the efficiency and profitability of food delivery
operations through the development of a comprehensive food delivery management system. The
system was designed to streamline the delivery process, enhance communication and tracking, and
optimize delivery routes. The system was developed using modern coding practices and was
thoroughly tested to ensure that it was secure, user-friendly, and compatible with various devices
and browsers. The project's results showed that the food delivery management system significantly
improved the delivery process, reduced delivery times, and enhanced customer satisfaction. The
system also provided businesses with greater visibility into delivery performance, enabling them
to make data-driven decisions and improve operational efficiency. The discussion highlighted the
potential of the food delivery management system to transform the food delivery industry by
enhancing the customer experience, improving operational efficiency, and driving business growth.
The project's success demonstrated the importance of coding and testing in developing
effective and efficient food delivery systems.

CHAPTER 7 CONCLUSION
AND FUTURE ENHANCEMENT
In conclusion, food delivery management is a complex process that involves various
entities and their relationships. An effective food delivery system must ensure seamless
communication and coordination between users, restaurants, delivery personnel, and
payment gateways. With the help of technology, it is possible to streamline the entire
33

Downloaded by Jaisurya (mjaisurya10@gmail.com)

 lOMoARcPSD|38739388

process, from browsing the menu to delivering the food, and provide an excellent user
experience. However, to achieve this, it is crucial to have a clear understanding of the
entities and their relationships, as well as the challenges and opportunities that come
with food delivery management. By taking a comprehensive approach and addressing
the needs and expectations of all stakeholders involved, it is possible to create a
successful and sustainable food delivery system.

34

Downloaded by Jaisurya (mjaisurya10@gmail.com)

 lOMoARcPSD|38739388

REFERENCES:
▪ http://www.w3schools.com/html/html_intro.asp
▪ http://www.w3schools.com/css/css_background.asp
▪ http://www.w3schools.com/js/js_datatypes.asp
▪ http://www.w3schools.com/sql/sql_insert.asp
▪ http://www.w3schools.com/sql/sql_update.asp
▪ http://www.w3schools.com/php/php_forms.asp
▪ Fundamentals of software engineering by Rajib mall, PHIlearning
▪ Web development and application development by Ivan Byross BPB publications

35

Downloaded by Jaisurya (mjaisurya10@gmail.com)