Coffee shop Management System Web Application

Project report of ISAD

Prepared by:

Rojip Rai (C30105210060)

BACHELOR OF INFORMATION & COMMUNICATION TECHNOLOGY

SCHOOL OF SCIENCE & TECHNOLOGY
VIRINCHI COLLEGE

i
 ACKNOWLEDGEMENT
This report is part of the 3rd semester of BICT course at Virinchi College. I would like to
thank the respected course facilitators, for the time and effort. We were grateful for the efforts of him.
I'm also grateful to the principal, "Pradeep Pant," and our academic facilitators Roshan KC sir
for giving us this great opportunity to learn so much via this completion. Furthermore, I'm grateful to
our seniors for assisting us in creating a thorough and concrete report based on their prior
experiences.
This project would not have been possible without his tremendous assistance, advice, and
recommendations from the beginning. His great and careful guidance in teaching us the style
benefited all of us. I am very grateful to all who has helped me accomplish this project and granting
me this precious opportunity so that we could learn many things through this completion.
Furthermore, we are thankful to our seniors and knowledgeable friends as well for assisting us in
creating a précised and concrete report through their previous experiences.

ii
 DECLARATION
I hereby declare that the project work entitled “Coffee shop management system” submitted
to the Virinchi College, is an original work done by me. I am responsible for the accuracy of all
opinions, technical comment, factual report, data, figure, illustrations and photographs highlighted
in this report.

Rojip Rai

BICT 3rd semester

iii
 APPROVAL SHEET
This is to certify that the report entitled “Coffee shop Management System Web
Application” submitted by Rojip Rai has been supervised. In my opinion, the research
follows the standard requirement for the Bachelor of Information and Communication
Technology.

Roshan KC

Academic Facilitator Academic Coordinator

Virinchi College

iv
 ABSTRACT

As the name specifies “COFFEE SHOP MANAGEMENT SYSTEM” is a web based application
developed for managing various activities in the coffee shop. Coffee Shop Management System is
based on a concept to maintain orders and management of a particular coffee shop. There are two
sections in this project, they are Coffee Ordering and user panel. By using this system he/she can
order the coffee items .By selecting Coffee Order the system displays a list of Available coffee drinks
and the user has to place an order with item quantity. After that, he/she precedes towards Order
confirmation and Payment methods. Cash and Credit are the two payment methods of this system, by
choosing Credit card method he/she has to enter Card Number and Pin Number for transactions.

v
Table of Contents
1. ACKNOWLEDGEMENT
2. ABSTRACT
3. INTRODUCTION
4. Problem statement
5. Objective
6. Scope
7. Methodology
8. Project Timeline
9. Literature Review
10. System analysis
11. Feasibility Analysis
12. System Design
13. System Implementation
14. Conclusion
15. References
16. Appendix

vi
 INTRODUCTION
Overview

This document fully and formally describes the requirements of the proposed said project
system. It sets out the functional and non-functional requirements and includes a description of
the user interface and documentation and training requirements.

Coffee Shop Management System is based on a concept to maintain orders and management of a
particular coffee shop. There are two sections in this project, they are Coffee Ordering and
Admin panel. By using this system, he/she can maintain ordering records of a day. By selecting
Coffee Order the system displays a list of Available coffee drinks and the user has to place an
order with item quantity. After that, he/she proceeds towards Order confirmation and Payment
methods. Almost 80% of the population are coffee lovers. Coffee Shop Management System in
java consists following modules such as; Login Module, Employee Module, Administrator
Module. This project is developed in java using Java (JDK), Servlets (JSDK), JSP. The role of
the administrator is to maintain employee information including operations like modifying,
deleting, updating the employee records and customer order records in the system.

Coffee Shop Management System is a web based application developed using JSP for front-end
design, JSP for coding, and SQL Server for back-end database. Now, talking about the Admin Panel,
an admin has full control of the system. He/she can view Total cash and card transactions of the day,
add coffee items, delete items, list instant items, item counter, backup system, preview instant orders.
While adding coffee items, the user should fill up the Item’s name, item’s quantity, item’s serial
number (without repeating) and price. The system also displays customer’s card number with
transaction amount for daily records. All the coffee orders of a day can be previewed easily from
Instant Order Preview Option from the Admin Panel.

PROBLEM DEFINITION

Lack of identity and a dull competitive edge

Coffee shops can be found on seemingly every corner, so it’s important for
coffee shop owners to establish an identity for their establishments. This means
identifying the type of customers you want to attract. For example, do you aim to cater
primarily to the “hipster” crowd, the “stroller brigade” of young parents looking for a place
to congregate with friends, or people who work in nearby offices? Once you’ve determined
who your target audience is, prevent an “identity crisis” by doing everything – from
choosing a name and location, to setting a menu – with that audience in mind.

The “wrong” menu

7
 Just as independent retailers sometimes carry only the merchandise, they
themselves like, coffee shop owners may be tempted to limit their menu so it jibes with
their personal preferences. This is a bad idea, as it has strong potential to alienate
customers.

To get the menu right, keep target customers’ tastes in mind when designing and
refining it. If you’re catering to coffee connoisseurs, consider offering a wide variety of
coffee drinks and coffees brewed from a wide range of beans. If your coffee shop attracts a
lunchtime office worker clientele, think about putting signature “grab-and-go” sandwiches on
the menu. If many customers come to your coffee shop with children in tow, include some
kid-friendly food and beverage options.

Inventory and pricing snafus

Running out of inventory—be it coffee beans or otherwise—is a sure fire way for
coffee shops and coffee shop owners to disappoint customers and put a crimp in business. In
the same vein, inappropriate pricing does the opposite of perking up the bottom line.

Overall management and customer service headaches

One common management-related problem faced by coffee shop owners is slow

service, especially in establishments that offer many customized coffee preparations. The
solution once more is an efficient POS system which, because it is designed for use in
foodservice environments (and preferably, can be configured specifically for coffee
shops), delivers on the promise of speed.

The best POS systems also make management hassle-free by tracking customer
information, using traffic patterns to forecast staffing needs, adjusting pricing, generating
reports that contain actionable information, facilitating tip reconciliation, and integrating with
other solutions, such as accounting software.

Objective

Almost 80% of the population are coffee lovers. Café is guaranteed to become the daily necessity for
all the coffee addicts. A place with good ambience where people can escape from their daily stress
and cherish with a morning cup of coffee. Our café offers home style delicious breakfast and snacks.
We focus on finding the most aromatic and exotic coffee beans. We have our branches in many
cities. We have a romantic ambience which attracts youth. Our café has spectacular interior designs
with stupendous taste of coffee. We have attached our menu which contains multi-cuisines at
attractive prices. In this paper, we have done SWOT analysis of our café to know our strengths and
weaknesses. We have also analyzed our opportunities and threats from the external environment

The usage of Coffee Shop Management System would ultimately reduce the overall management
8
costs thus ensuring greater profits and reduced burdens. The system is very easy to use and can adjust
into any business frame.

Scope
This system will help to manage and run the Coffee shop systematically. In this management
system, we will provide an app that can be used by cafe’s employee to take order. So that owner
of shop can evaluates the whole system. This will ultimately lead to hire less waiters and create
opportunity to appoint more chefs and better shop to serve coffee faster. Employee can take
payment which will managed into the software.

Methodology
The primary goal of this project was to develop an application that allows users to list out
their tasks and be able to complete them. I conducted qualitative research to acquire information. The
majority of the material I gleaned from the internet came from sites like W3Schools and Java Point.
The goal of using these websites was to go deeper into every minor element of Java and MySQL
development.

Project Timeline

9
 Gantt Chart
29-mar 03- Gantt Chart
07-apr12-apr16-may21-may03-june01-Mar
Selection of the Project Hardware mayma
Specification Technology yAug chChChart
Selection Requirement Analysis
Feasibility Study Planning and
Scheduling Conceptual Model
Design
System Design Implementation
Testing Deployment

Figure ( Project Timeline)

10
 LITERATURE REVIEW
Introduction
We have studied Java language, now we come to the real-life problems and see how
we can solve them. Here I will use Java Program to develop one real life project with a
simple project life cycle using Net beans. This document fully and formally describes the
requirements of the proposed said project system. It sets out the functional and non-functional
requirements and includes a description of the user interface and documentation and training
requirements.

Proposed system
The proposed system provides user friendly interface and also provides powerful and efficient
database management system. The aim of proposed system is to develop a system of improved facilities.
The existing system work is done manually thus hampering its accuracy and effectiveness. The proposed
system can overcome the limitations of the existing system. The system provides proper security and
reduces the manual work. The existing system has several disadvantages and many more difficulties to
work. The proposed system tries to eliminate or reduce these difficulties up to some extent. The
proposed system will help the user to reduce the workload and mental conflict. Through this system it is
possible to print various reports and bills for the organization. The aim of the proposed system is to
develop a system of improved facilities.

 Security of data.
 Ensure data accuracy.
 Proposed control of the Higher Authority.
 Minimum time needed for the various processing.
 Greater efficiency.
 Better services.
 User friendliness and interactive.
 Minimum time required.

Software Development Life Cycle

The Waterfall Model is a linear sequential flow. In which progress is seen as flowing steadily downwards (like a
waterfall) through the phases of software implementation. This means that any phase in the development
process begins only if the previous phase is complete. The waterfall approach does not define the process to go
back to the previous phase to handle changes in requirement. The waterfall approach is the earliest approach
and most widely known that was used for software development.

11
 Figure (Waterfall Model Design)

Conclusion

In the conclusion ,this project has some additional features and services like:
● We included features and operations in detail, including screen layouts.
● We define the problem on which we are working in the project.
● Register as an user and handle the content.

12
 SYSTEM ANALYSIS

System requirement

Introduction

Systems analysis is the process by which an individual (s) studies a system such that an information system
can be analyzed, modeled, and a logical alternative can be chosen. Systems analysis projects are initiated for
problems, opportunities, and directives.

HARDWARE REQUIREMENTS

Content Description
HDD 20 GB Min
40 GB Recommended
RAM 512 GB Min
1 GB Recommended

SOFTWARE REQUIREMENTS

Operating System Windows 10

Browser Chrome, Edge, IE

Web/Application Server Tomcat 8.5.5

Database Server Apache
Database Connectivity JDBC
Other Tools & Technologies Java (JDK), Servlets (JSDK),
JSP

Table (Software and Hardware Requirement Specification)

13
Conceptual modeling

ER diagram

Figure (Er-diagram)

14
 Technologies Used

Java
Java language was developed by James Gosling and his team at sun microsystems
and released formally in 1995. Its former name is oak. Java Development Kit 1.0 was
released in 1996. to popularize java and is freely available on the Internet. Java is loosely
based on C++ syntax, and is meant to be an Object- Oriented Structure of java is midway
between an interpreted and a compiled language. java programs are compiled by the java
compiler into byte codes which are secure and portable across different platforms.
TML

HTML (Hypertext Markup Language) is used to create hypertext documents with

hyperlinks embedded in them. it consists of tags embedded in the text of a document with
HTML. We can build web pages or web documents. it is basically a formatting language and
not a programming language. The browser reading the document interprets markup tags to
help format the document for subsequent display to a reader. HTML is a language for
describing structured documents. HTML is a platform-independent. WWW (world wide web)
pages are written using HTML. HTML tags control in part the representation of the WWW
page when viewed with a web browser. The browser interprets HTML tags in the web
document and displays them. Different browsers show data differently.
avaScript

JavaScript is a general-purpose prototype-based, object-oriented scripting language

developed jointly by sun and Netscape and is meant for the WWW. it is designed to be
embedded in diverse applications and systems, without consuming much memory. java script
borrows most of its syntax from Java and inherits from AWK and PERL, with some indirect
influence from self in its object prototype system. Java scripts are dynamically typed that is
programs do not declare variable types, and the type of variable is unrestricted and can
change at runtime. the source can be generated at run time and evaluated against an arbitrary
scope. Typical implementations compile by translating the source into a specified byte code
format, to check syntax and source consistency.

15
 script is a high-level scripting language that does not depend on or expose particular machine
representations or operating system services. It provides automatic storage management,
typically using a garbage collector.
Servlets

Servlet provides a Java-based solution used to address the problems currently

associated with doing server-side programming, including inextensible scripting solutions,
platform-specific APIs, and incomplete interfaces. servlets are objects that conform to a
specific interface that can be plugged into a Java-based server. Servlets are to the server-
side what applets are to the client-side -- object byte codes that can be dynamically loaded
off the net. They differ from applets because they are faceless objects (without graphics or a
GUI component). They serve as platform-independent, dynamically-loadable, pluggable
helper byte code objects on the server-side that can be used to dynamically extend server-
side functionality. Servlets are modules that extend request/response-oriented servers, such
as Java-enabled web servers. For example, a SERVLET might be responsible for taking
data in an HTML order-entry form and applying the business logic used to update a
company's order database.
Session

Session tracking is a flexible, lightweight mechanism that enables stateful

programming on the web. Its general implementation serves as a basis for more sophisticated
state models, such as persistent user profiles or multi-user sessions. Session is a series of
requests from the same user that occur during a time period. This transaction model for
sessions has many benefits over the single-hit model. It can maintain state and user identity
across multiple page requests. It can also construct a complex overview of user behavior that
goes beyond reporting user hits.

Feasibility Analysis:

There are 5 main kinds of feasibility analysis as explained below:-

Technical Feasibility
This assessment focuses on the technical resources available to the organization. It helps organizations
determine whether the technical resources meet capacity and whether the technical team is capable of
converting the ideas into working systems. Technical feasibility also involves the evaluation of the hardware,
software, and other technical requirements of the proposed system.
Economic Feasibility
This assessment typically involves a cost/ benefits analysis of the project, helping organizations determine the
viability, cost, and benefits associated with a project before financial resources are allocated. It also serves as
an independent project assessment and enhances project credibility—helping decision-makers determine the
positive economic benefits to the organization that the proposed project will provide.
Legal Feasibility
This assessment investigates whether any aspect of the proposed project conflicts with legal requirements like
zoning laws, data protection acts or social media laws. Let’s say an organization wants to construct a new
office building in a specific location. A feasibility study might reveal the organization’s ideal location isn’t
zoned for that type of business.
16
 Operational Feasibility
This assessment involves undertaking a study to analyze and determine whether—and how well—the
organization’s needs can be met by completing the project. Operational feasibility studies also examine how a
project plan satisfies the requirements identified in the requirements analysis phase of system development.
Scheduling Feasibility
This assessment is the most important for project success; after all, a project will fail if not completed on time.
In scheduling feasibility, an organization estimates how much time the project will take to complete. When
these areas have all been examined, the feasibility analysis helps identify any constraints the proposed project
may face.

17
 SYSTEM DESIGN

Employee Details Validity Check

Administrator

System
Order Processing

Employee

Database

Use Case Diagram

Figure (use case diagram)

Introduction

 System design

System design is the process of defining the elements of a system such as the architecture, modules and
components, the different interfaces of those components and the data that goes through that system. It is
meant to satisfy specific needs and requirements of a business or organization through the engineering of a
coherent and well-running system.

DESIGN:
Context Diagram:

18
User Admin

Register Login

Login Add Product

Delete Product
Add to cart

Coffee shopAccept
Receipt
Management system order

OrderDelivery

Fig. Context diagram

19
20
DFD LEVEL 1

21
22
23
 SYSTEM IMPLEMENTATION

Testing is essential for quality assurance and assuring the software's dependability. Its
primary role is to detect faults. Following the coding step, testing is carried out to ensure that the new
system functions properly. Testing is the process of running software to detect faults. It is a thorough
examination to see whether the objectives have been realized and the user criteria have been met.
During the testing phase, a system is tested using diverse test data. The preparation of test data is
critical in system testing. Following the preparation of the test data, the system under investigation is
tested using the test data. The following testing steps were used to identify and repair errors, and the
corrections were documented for future reference. As a result, the system is subjected to a series of
tests before it is suitable for coding. This phase is critical for the proper execution of the software
product since code is the only product that can be performed regularly and whose real behavior can
be seen. As a result, the purpose of testing is to discover requirements, design, and code flaws in the
software.
V & V Plan

Introduction

The purpose of the V&V Plan is to identify the activities that will establish compliance with
the requirements (verification) and to establish that the system will meet the customers' expectations
(validation).
Test Plan

End-to-end testing is a technique that tests the entire software product from
beginning to end to ensure the application flow behaves as expected. It defines the
product's system dependencies and ensures all integrated pieces work together as expected.

V & V Results

Introduction and overviews

The system testing stage is significant because it helps the application meet its functional,
technical, and business requirements. System testing is very important because it verifies that the
application meets the technical, functional, and business requirements specified by the customer.

24
 CONCLUSION
Coffee Shop Management is a project developed by us which aims at providing an
automated management system for Coffee Shop. This project deals with solving the errors caused due to
manual work. The project also provides security of the data entered by the admin. The project Coffee
Shop Management is therefore targeted towards improving the existing system by making it automated.
All the details are entered into the system with ease. The project focuses on entering the information and
presenting different details in an easy and intelligible way.

REFERENCES
Why is Testing Necessary? (n.d.). Retrieved from ToolsQA:
https://www.toolsqa.com/software-testing/istqb/why-is-testing-necessary
Yakub. (2008). Sistem Basis Data; Tutorial Konseptual. Yogyakarta: Graha Ilmu.
Connolly, T., & Begg, C. (2010). Database Systems A Practical Approach to Design,
Implementation, and Management (5 ed.). Boston: Pearson Education.

Dyer, R. J. (2008). MySQL in a Nutshell (2nd ed.). Sebastopol, CA: O’Reilly Media, Inc.

What is End-to-End (E2E) Testing? All You Need to Know. (n.d.). Retrieved from katalon:
https://katalon.com/resources-center/blog/end-to-end-e2e-testing

Why is Testing Necessary? (n.d.). Retrieved from ToolsQA:

https://www.toolsqa.com/software-testing/istqb/why-is-testing-necessary

Yakub. (2008). Sistem Basis Data; Tutorial Konseptual. Yogyakarta: Graha Ilmu.

Web Development Java Server Pages, Fields, D/ Kolb, M. Computer Hut

Theory & Problems Of Programming With Java , Hubbard, J. R. 2nd ed TMH

Test plan; https://www.guru99.com/

25
 APPENDIX

i. User login

ii. Home Page

26
iii. Menu

27
 iv. About us

v. Contact us

28
29
30