Page | 1
WEB APPLICATION DEVELOPMENT PROJECT
Page | 2
PRESIDENT INSTITUTE OF COMPUTER APPLICATIONS
T.Y. B.C.A (2022-2023)
A Project Report on Coffee Shop Management
Develop By: -
NAME ENROLMENT NUMBER
SIDDHAPURA AYUSH SUDHIRBHAI 202112102606
PATEL YOHESH GIRISHBHAI 202112102562
SOLANKI MOHIT JIGNESHBHAI 202112102610
PRESIDENT INSTITUTE OF COMPUTER APPLICATIONS
AHMEDABAD
Affiliated by GUJARAT UNIVERSITY
Index
Sr. No. Topic Page No.
Page | 3
1. Company certificate ………………………………….…………....……
03
2. Company Profile …………………………………….............................04
4. Acknowledgement……………………………………..........................05
5. Project
Details……………………………………...................................06
5.1 Existing
System….......................................................06
5.2 Proposed System………............................................06
6. System Tools…………………………………….....................................07
7. Modules………………............................................................................08
7.1 Admin modules......................................................... 08
7.2 User modules..............................................................08
8. Use Case Diagram…………………………..........................................09
8.1 Admin Use Case Diagram…...................................10
8.2 User Use Case Diagram …………...........................11
9. Activity Diagram……………………….…….......................................12
9.1 Admin Activity Diagram …………………………...13
9.2 User Activity Diagram ……………………………... 14
10. Class Diagram……………………………………..................................15
11. Sequence Diagram……………………………….……………….……..17
12. Entity Relationship Diagram........................................................19
13. Data Dictionary……………………………………...............................21
Page | 4
COMPANY PROFILE
Page | 5
Solulab has managed to make its own position in IT Sector. We
are involved in web development, App Development, IOT
solutions, Graphics & Designing, Project training, Digital
Marketing, Domain & Hosting services, SMS services etc.
Our expertise and skill-set include the design and development
of websites.
In the span of many years we have managed to deliver all
projects on time with utmost accuracy to our clients across the
globe.
We have dedicated teams of experienced and hardworking
developers, our developers who are always willing to take new
challenges and looking forward to learn new things, are hearts
of this company.
Connect with Us Now
Call Us: +91 9662460193
Visit Our Website: https://solulab.com/
Page | 6
Acknowledgement
It really gives us a great pleasure and deep satisfaction to
presenting this report of our project work as a part of BCA
course arranged in order to gain the practical knowledge in
system development.
We took this opportunity to express our sincere gratitude to
several people with whose help and encouragement, we have
been able to complete this project rather successfully.
We express a deep sense of gratitude to our project guide
incharge prof. RITA VADHVANA valuable suggestions and
continuous encouragement without which the project would
not have been a success.
We also thank to our college PRESIDENT INSTITUE OF
COMPUTER APPLICATION
Page | 7
PROJECT PROFILE
Existing System:
No computerized system.
Paper work is performed.
Data retrieving is very time consuming.
It is difficult to find out the oldest record which is already
visited in the past.
Existing system is a manual system so there are lot of
problems in handling and managing the data.
Proposed System:
The core objective is to automate the system to computerize,
which simplifies the work and is easier, than the recent
manual and time-consuming process in COFEE SHOP.
The proposed system will be hosted widely on the web
(WWW – World Wide Web), for future enhancement and
growth.
Page | 8
This system will be developed for better time utilization and
management.
This system also provides easy ordering system by just scan
QR Code.
SYSTEM TOOLS
Development tools and Technologies:
Frontend: HTML, JAVASCRIPT, CSS
Backend: PHP, MYSQL
Other tools: XAMPP, VScode
Operating System: Windows 7,8,10, Android, iOS, ubuntu,
Linux
Page | 9
MODULES:
--> Admin
-->User
Admin
● Login
● Manage Item
● Manage Order
● Manage Bill
● Manage Payment
● Feedbacks
● Logout
User
● View Items
● View Bills
● Make Payment
Page | 10
● Feedback
USE CASE DIAGRAM
Page | 11
User Use Case Diagram
Page | 12
Page | 13
Admin Use Case Diagram
Page | 14
ACTIVITY DIAGRAM
Admin Activity Diagram
Page | 15
Page | 16
User Activity Diagram
Page | 17
CLASS DIAGRAM
Page | 18
Page | 19
SEQUENCE DIAGRAM
Page | 20
Page | 21
ENTITY RELATIONSHIP DIAGRM
Page | 22
Page | 23
DATA DICTIONARY
Page | 24
Admin Table
Field Type Description Constraint
Id Int (6) Admin id PK
Name Varchar (15) Name of the admin Not Null
Password Varchar (8) Password of admin Required
Customer Table
Field Type Description Constraint
Id Int (6) Customer id PK
Name Varchar (25) Customer name Required
Order Table
Field Type Description Constraint
Id Int (6) Order id PK
Specialization Varchar (25) Specialization of item Not Null
Item_id Int (6) Item id FK
C_id Int (6) Customer id FK
Price Numeric (8) Item price Not Null
Table_no Numeric (2) Table number Not Null
Specialization Table
Field Type Description Constraint
Page | 25
Id Int (6) Specialization id PK
Specialization Varchar (25) Name of specialization Not Null
Item Table
Field Type Description Constraint
Id Int (6) Item id PK
Specialization Varchar (25) Item specialization Not Null
Name Varchar (25) Item name Required
Price Numeric (10) Item prize Not Null
Field Type Description Constraint
Id Int (6) Bill id PK
Date Int (8) Bill date Required
Total_a Numeric (10) Bill amount Not Null
Page | 26
