FAMILY FLAVORS

A PROJECT REPORT

Submitted
by

Krishna Sharma
Riddhi Upadhyay

In fulfillment for the award of the

degree of
BACHELOR OF ENGINEERING
in
Computer Engineering

LDRP Institute of Technology and Research, Gandhinagar

Kadi Sarva Vishwavidyalaya

 January, 2024

LDRP INSTITUTE OF TECHNOLOGY AND

RESEARCH GANDHINAGAR

CE-IT Department

CERTIFICATE
This is to certify that the Project Work entitled “Family Flavors” has been carried out by Krishna
Sharma (21BECE30294) and Riddhi Upadhyay (21BECE30333) under my guidance in
fulfilment of the degree of Bachelor of Engineering in Computer Engineering Semester-6 of Kadi
Sarva Vishwavidyalaya University during the academic year 2023-2024.

Name of Guide Name of HOD

Internal Guide Head of the Department

LDRP ITR LDRP ITR

 Presentation-I for Project-I

1. Name & Signature of Internal Guide

2. Comments from Panel Members

3. Name & Signature of Panel Members

 ACKNOWLEDGEMENT

With immense pleasure we would like to present the report on our topic “Family Flavors”.
I am thankful to all that have helped us for successful completion of our project and
providing us courage for completing the work.

Firstly, We are thankful to LDRP-ITR for undertaking this project. We are sincerely
indebted to Prof. Vishal Barot for giving us the opportunity to work on this project. His
continuous guidance and help have proved to be the key to our collective success in
overcoming the challenges that we have faced during the project work.His support made
the project making experience a pleasantly memorable one. Without his help at all stages in
spite of his own workload; the completion of the project would not have been possible.

We are thankful to my Head of the Department Dr. Sandip Modha, our internal faculty guide
Prof. Vishal Barot for providing guidance throughout our work giving us their valuable time.

At last we would like to thank our Family and friends who have directly or indirectly
helped us in making the project work successfully.

Krishna Sharma
(21BECE30294)

Riddhi Upadhyay
(21BECE30333)

I
 ABSTRACT

FamilyFlavors is reshaping the culinary experience, making it easier for

hostellers, busy professionals, and individuals who seek delicious, home-cooked
meals without the hassle of cooking or dining out. Our platform bridges the gap
between homemakers and those in need of wholesome, homemade food by
providing a seamless pick-up and delivery service under our distinctive brand.
Under the FamilyFlavors banner, we offer a refined solution that goes beyond a
mere food service, creating an ecosystem where homemakers thrive, earning
and growing as culinary entrepreneurs. This is not just about delivering meals;
it's about connecting communities, supporting small businesses, and celebrating
the authentic flavors of homemade cuisine.

II
 LIST OF FIGURES

NO NAME PAGE NO

1 Entity Relationship Diagram 12

2 Context level DFD 13

3 First level DFD 14

4 Activity Diagram 15
5 Sequence Diagram 17

6 Collaboration Diagram 19

7 Deployment Diagram 20

8 Class Diagram 21

9 Use Case Diagram of Student 22

10 Use Case Diagram of faculty 24

11 Use Case Diagram of Admin 26

12 Use Case Diagram of Parent 28

13 Functional Diagram of Student 29

14 Functional Diagram of Faculty 30

15 Functional Diagram of Admin 31

16 Functional Diagram of Parent 31

III
 LIST OF TABLES

NO NAME PAGE NO

1 Users Table 40

2 Subscription Table 40

3 Order Table 40

4 Menu Table 41

5 Payment Table 41

6 Chef Table 42

8 Meal Table 42

9 Tiffin Table 43
10 Admin Table 43

IV
 TABLE OF CONTENTS

NO CHAPTER NAME PAGE NO

Acknowledgement I

Abstract II

List of Figures II

List of Tables IV

Table of Contents V

1 Introduction 1

1.1 Introduction 2

1.2 Aims and Objective of the work 2

1.3 Brief Literature Review 2

1.4 Problem definition 3

1.5 Plan of their work 3

2 Technology and Literature Review 4

2.1 Technology 5

2.2 Literature 5

3 System Requirements Study 7

3.1 User Characteristics 8

3.2 Hardware and Software Requirements 8

3.2.1 Software Requirements 9

3.2.2 Functional Diagram of Admin 9

3.2.3 Functional Requirements 9

3.2.4 Non Functional Requirements 10

3.3 Assumptions and Dependencies 10

V
 3.3.1 Assumptions 10

3.3.2 Dependencies 10

4 System Design 11

4.1 Entity Relationship Diagram 12

4.2 Data Flow Diagram 13

4.2.1 Context Level DFD 13

4.2.2 First Level DFD 14

4.2.3 Second Level DFD 15

4.3 Activity Diagram 17

4.4 Sequence Diagram 19

4.5 Collaboration Diagram 20

4.5.1 Collaboration Diagram of User 20

4.5.2 Collaboration Diagram of Chef 21

4.5.3 Collaboration Diagram of Admin 22

4.6 Deployment Diagram 24

4.7 Class Diagram 26

4.8 Use Case Diagram 28

4.9 Functional Diagram 31

4.10 Wire Frame 33

5 Data Dictionary 39

VI
6 Result, Discussion and Conclusion 45

6.1 Result 46

6.2 Discussion 46

6.3 Conclusion 46

7 References 47

7.1 References 47

VI
I
 1 INTRODUCTION

 INTRODUCTION

 AIMS AND OBJECTIVE OF THE WORK

 BRIEF LITERATURE REVIEW

 PROBLEM DEFINITION

 PLAN OF THEIR WORK

LDRP-ITR 1
1.1 Introduction

In the contemporary era of higher education, the integration of advanced technologies

has become a driving force in reshaping the student experience. Among these
innovations, the introduction of a College Chatbot stands out as a transformative
solution. This section provides an overview of the College Chatbot, exploring its
significance in enhancing communication, accessibility, and efficiency within the
college ecosystem.

1.2 Aims and Objectives of the Work

The primary aim of this work is to conceptualize, develop, and implement a College
Chatbot tailored to the specific needs and challenges of our academic institution. The
objectives include enhancing student engagement, streamlining administrative
processes, and providing a responsive platform for information retrieval. Through
these goals, the project seeks to contribute to a more effective and user-friendly
educational environment.

1.3 Brief Literature Review

A brief exploration of the existing literature sets the stage for understanding the
landscape of chatbot implementation in higher education. Examining the successes
and challenges faced by similar systems provides valuable insights that guide the
development and deployment of the College Chatbot. This section lays the
foundation for the study by drawing on relevant research and real-world examples.

LDRP-ITR 2
1.4 Problem Definition

Identifying the challenges and gaps in the current college communication and administrative
processes forms a crucial aspect of this work. This section outlines the specific problems
faced by students and administrative staff, emphasizing the need for an innovative solution
like the College Chatbot. By clearly defining the issues at hand, the project aims to address
and mitigate these challenges through technology.

1.5 Plan of their work

The subsequent section outlines the strategic plan for the development and implementation of the
College Chatbot. This includes the stages of design, development, testing, and deployment.
Additionally, it highlights the collaborative efforts involving stakeholders, development teams, and
end-users. The plan of work provides a roadmap for the successful integration of the College Chatbot
into the college ecosystem, ensuring a smooth transition and optimal functionality.

LDRP-ITR 3
 2 TECHNOLOGY AND LITERATURE REVIEW

 INTRODUCTION

 AIMS AND OBJECTIVE OF THE WORK

 BRIEF LITERATURE REVIEW

 PROBLEM DEFINITION

 PLAN OF THEIR WORK

LDRP-ITR 4
2.1 Technologies

Collegebot embraces a cutting-edge technology stack, ensuring a robust, scalable, and

efficient platform for users.

2.1.1 Frontend Development

 HTML: In the context of a chatbot, HTML is typically used for creating the frontend
or user interface that users interact with. While chatbots often involve more dynamic
and interactive elements handled by backend technologies, HTML remains essential
for structuring the layout and content of the chatbot interface.

2.1.2 Backend Development

 Python; Python's natural language processing (NLP) capabilities, supported by

libraries like NLTK or spaCy, enhance the chatbot's ability to understand and respond
to user inputs intelligently. Python plays a central role in the backend of a chatbot,
providing the necessary tools for processing user inputs, managing conversations, and
delivering meaningful responses.

2.2 Literature Review

A literature review on chatbots in a college context reveals a growing body of

research and applications aimed at enhancing student experiences and administrative
processes. Scholars have explored the integration of chatbots in higher education to
provide personalized assistance, streamline information retrieval, and improve
communication. Studies highlight the potential of Natural Language Processing
(NLP) techniques within chatbots to better understand and respond to student queries
effectively.

LDRP-ITR 5
  Web Development Best Practices: Aligning with established best practices in web
development, we prioritized security, scalability, and user experience. This
included implementing secure authentication mechanisms, optimizing frontend
performance, and ensuring data integrity.

 Draw.io: Utilizing Draw.io, a versatile diagramming tool, facilitated the creation of

detailed architecture diagrams. This visual aid enhanced our team's communication
and understanding of the system's structure.

This technology and literature review guided the strategic choices and implementation details
of this platform, ensuring a modern, secure, and user-friendly experience .

LDRP-ITR 6
 3 SYSTEM REQUIREMENTS STUDY

 USER CHARACTERISTICS

 HARDWARE AND SOFTWARE REQUIREMENTS

 ASSUMPTIONS AND DEPENDENCIES

LDRP-ITR 7
3.1 User Characteristics

Analyzing user characteristics is an important aspect of any project. It allows us to clearly

define and focus on who the end users are for the project. Also, it allows checking the
progress of the project to ensure that we are still developing the system for the end users. The
platform caters to three primary user roles:

User:

 Roles: Individuals explore a variety of culinary options to satisfy their diverse tastes
and preferences. Subscribers seek convenient, home-cooked meals for a delightful
dining experience.
 Responsibilities: Placing orders for meals, Managing subscriptions and preferences.
 Profiles: Varied age groups and demographics. Individuals with busy lifestyles.
 Expectations: User-friendly platform for seamless order placement. Access to a
diverse menu and personalized subscriptions.

Chef:

 Role: Culinary enthusiasts and homemakers showcasing their cooking skills.

 Responsibilities: Preparing and listing meals on the platform. Managing orders and
interacting with users.
 Profile: Cooking enthusiasts with diverse culinary backgrounds. Individuals
passionate about homemade meals.
 Expectations: Efficient tools for listing and managing meals. Interaction with a
community of food enthusiasts.

Admin:

 Role: Platform administrators overseeing system operations.

 Responsibilities: Managing users, orders, chefs, and overall platform functionality.
 Profile: System administrators with analytical skills. Individuals ensuring
system integrity and user satisfaction.
 Expectations: Effective tools for system monitoring and user management. Seamless
platform operation.

3.2 Software and Hardware Requirements

Software and Hardware Requirements are used to describe the minimum hardware and
software requirements to run the Software. These requirements are described below.

LDRP-ITR 8
3.2.1 Software Requirements

 Client:

• Operating System: Windows or Linux

• Web Browser: Any HTML Compliant Browser

 Server:

• Operating System: WINDOWS or LINUX SERVER OS

• Technologies: Python

3.2.2 Hardware Requirements

 Client:

 Processor: Modern processors (dual-core or higher)

 Memory (RAM): Adequate RAM
 Display: Standard monitor or screen
 Input Devices: Keyboard and mouse or equivalent

 Server:

 Processor: Multi-core processors

 Memory (RAM): 8GB or more
 Storage: SSDs recommended
 Network: High-speed internet connection

3.2.3 Functional Requirements

The basic features available in the system are as follows:

• User Registration and Authentication: Seamless user registration and login process.
• Meal Listing and Order Management: Tools for chefs to list meals and manage orders.
• Subscription Management: User-friendly interface for managing subscriptions.
• Community Interaction: Features for user and chef interaction.
• Personalization: Customizable preferences for users.

LDRP-ITR 9
3.2.4 Non Functional Requirements

Following is a list of non functional requirements:

• Performance: The system guarantees 24/7 accessibility, accommodating at least 100

concurrent users without performance issues.
• Security: User passwords are encrypted using the Caesar cipher method, enhancing
data security and confidentiality.
• Reliability: The system is accessible round the clock, ensuring reliability for end-
users' tasks and projects.
• Availability: A stable internet connection is maintained for database server nodes,
ensuring continuous system availability.
• Portability: The web application is highly portable, accessible from any operating
system with a compatible web browser, enhancing user flexibility and convenience.

3.3 Assumptions and Dependencies

3.3.1 Assumptions

• Database transactions are assumed to be secure and reliable.

• User is the person having enough knowledge for the traversing operation.
• We will provide a user friendly interface so that any user can easily navigate through the
system, but he/she should be capable of providing valid credentials for successful login.
• The server used for data storing is always secured.

3.3.2 Dependencies

• The system is dependent upon the user’s valid credentials. If user inputs wrong username
or password, he/she will not be allowed to login to the system.
• This application depends on the server and internet as all the information is collected and
then stored in the server through secure internet connection.
• All the users of the system will be assigned a specific role. According to these roles each
and every user will be allowed to access predefined set of features.

LDRP-ITR 10
38
 5 DATA DICTIONARY

 USERS TABLE

 SUBSCRIPTION TABLE

 ORDER TABLE

 MENU TABLE

 PAYMENT TABLE

 CHEF TABLE

 MEAL TABLE

 TIFFIN TABLE

 ADMIN TABLE

LDRP-ITR 39
5.1.1 Users Table:

Field Data Type Length Constraint Reference Table

UserID Number 6 Primary Key

FirstName varchar2 100 Not Null

LastName varchar2 100 Not Null

PhoneNumber varchar2

Email varchar2 100 Unique

Password varchar2 200 Not Null

Address varchar2

5.1.2 Subscription Table:

Field Data Type Length Constraint Reference Table

SubscriptionID Number 6 Primary Key

StartDate Date - -

EndDate Date - -

Plan varchar2 - -

Status varchar2 - -

5.1.3 Order Table:

Field Data Type Length Constraint Reference Table

OrderID Number 6 Primary Key

OrderDate Date - -

LDRP-ITR 40
Field Data Type Length Constraint Reference Table

TotalAmount Decimal - -

DeliveryDate Date - -

Status varchar2 - -

5.1.4 Menu Table:

Data Reference
Field Type Length Constraint Table

MenuItemID Number 6 Primary Key

ItemName varchar2 - -

Description varchar2 - -

Foreign Key (References ChefID in Chef

ChefID Number 6 Table) Chef

Foreign Key (References MealID in Meal

MealID Number 6 Table) Meal

Category varchar2 - -

5.1.5 Payment Table:

Field Data Type Length Constraint Reference Table

PaymentID Number 6 Primary Key

PaymentDate Date - -sss

Amount Decimal - -

PaymentMethod varchar2 - -

Status varchar2 - -

LDRP-ITR 41
5.1.6 Chef Table:

Field Data Type Length Constraint Reference Table

ChefID Number 6 Primary Key

FullName varchar2 - -

Specialization varchar2 - -

PhoneNumber varchar2 - -

Email varchar2 - -

Password varchar2 - -

Address varchar2 - -

5.1.7 Meal Table:

Data Reference
Field Type Length Constraint Table

MealID Number 6 Primary Key

Foreign Key (References ChefID in Chef

ChefID Number 6 Table) Chef

Foreign Key (References MenuItemID in

MenuItemID Number 6 Menu Table) Menu

Foreign Key (References TiffinID in

TiffinID Number 6 Tiffin Table) Tiffin

Quantity Number - -

PreparationDate Date - -

ExpirationDate Date - -

LDRP-ITR 42
 Data Reference
Field Type Length Constraint Table

Status varchar2 - -

Image Blob - -

Title varchar2 - -

Description varchar2 - -

Price Decimal - -

Type varchar2 - -

5.1.8 Tiffin Table:

Data Reference
Field Type Length Constraint Table

TiffinID Number 6 Primary Key

Foreign Key (References ChefID in Chef

ChefID Number 6 Table) Chef

TiffinType varchar2 - -

Price Decimal - -

Description varchar2 - -

Status varchar2 - -

5.1.9 Admin Table:

Field Data Type Length Constraint Reference Table

AdminID Number 6 Primary Key

Username varchar2 - -

LDRP-ITR 43
Field Data Type Length Constraint Reference Table

Password varchar2 - -

AdminName varchar2 - -

LDRP-ITR 44
 6 RESULT, DISCUSSION AND CONCLUSION

 RESULT

 DISCUSSION

 CONCLUSION

LDRP-ITR 45
 6.1 Result

The implementation of CollegeBot, a chatbot tailored for the college environment,

yielded promising outcomes. The chatbot effectively addressed user inquiries, provided
timely information, and enhanced the overall accessibility of college-related services.
User interactions demonstrated a positive response to the chatbot's capabilities,
showcasing its utility in assisting students, faculty, and staff with a wide range of queries.

6.2 Discussion

The discussion section delves into the performance, challenges, and potential improvements
of CollegeBot. It explores user feedback, the accuracy of responses, and the chatbot's ability
to adapt to various types of inquiries. Considerations regarding the integration of emerging
technologies, such as sentiment analysis or advanced machine learning algorithms, are also
discussed. Moreover, the discussion explores the scalability of CollegeBot to handle
increased user demand and diverse use cases, addressing any identified limitations.

6.3 Conclusion
In conclusion, CollegeBot demonstrates significant potential as a valuable tool within
the college ecosystem. The chatbot streamlines information retrieval, enhances user
experience, and contributes to the efficiency of college-related processes. While
acknowledging its successes, the conclusion also highlights areas for future
development and improvement. CollegeBot stands as a testament to the evolving
landscape of digital assistance in educational institutions, offering a foundation for
ongoing enhancements to meet the dynamic needs of the college community.

LDRP-ITR 46
 7 REFERENCES

 REFERENCE

LDRP-ITR 47
7.1 References

1. Draw.io: Diagramming and Flowcharting Tool. https://www.draw.io.

2. https://www.ijraset.com/research-paper/paper-on-college-enquiry-chatbot

3. https://www.jetir.org/papers/JETIR2302353.pdf

4.

LDRP-ITR 48