A
Micro project report on
“Restaurant Management
System” SUBMITTED TO M.S.B.T.E.,
Mumbai
For the Award of
DIPLOMA IN COMPUTER ENGINEERING
Roll no Name of Student Enrollment no
13 Rohini Damaji Mharnur 23212470123
21 Shravani Sunil Kokate 23212470131
22 Sanika Sunil Zende 23212470132
30 Rutuja Promod Kalel 23212470140
UNDER THE GUIDANCE OF
Ms. M.B.patil
DEPARTMENT OF COMPUTER
ENGINEERING NBA ACCREDIATED
SVERI’s College of Engineering (Polytechnic), Gopalpur
Pandharpur-413304
2024-25
AFFILIATED TO
M.S.B.T.E.
Evolution sheet for Micro Project
Academic Year:- 2024-25 Name of Faculty:- Ms. M.B.Patil
Course:- Computer Engineering Course Code:- CO4K
Subject:- Python Subject Code:- 314318
Semester:- 4 Scheme:- K
Title of Project:-
Major Learning Outcomes achieved by students by doing the Project:
(a)Practical
a. Design E-R diagram and create normalized database on given data.
Outcomes:
(b) Unit 1. Identify the relevant database mode in the
Outcomes in given situation.
Cognitive domain: 2. Draw the ER diagram of the given database
and identify relation between the entities.
(c) Outcomes in 1. Select appropriate ER Diagram Notations and Normal Forms.
Affective Domain: 2. Follow safety measures.
3. Follow ethical practices.
Comments/Suggestions about team work/leadership/inter-personal communication (if any)
Marks out of 4
Marks out of 6 Total
for
for performance mars
Roll No Name of students performance in
in group activity out of
oral/
10
Presentation
13 Rohini Damaji Mharnur
21 Shravani Sunil Kokate
22 Sanika Sunil Zende
30 Rutuja Promod Kalel
Guide Ms. M.B.Patil
SVERI’s COLLEGE OF ENGINEERING (POLYTECHNIC), PANDHARPUR.
CERTIFICATE
This is to certify that the Project report
entitled
“Restaurant Management System”
Submitted by
Roll no Name of Student Enrollment no
13 Rohini Damaji Mharnur 23212470123
21 Shravani Sunil Kokate 23212470131
22 Sanika Sunil Zende 23212470132
30 Rutuja Promod Kalel 23212470140
is a bonafide work carried out by above students, under the guidance of Ms. M.B.Patil and it is
submitted towards the fulfillment of requirement of MSBTE, Mumbai for the award of Diploma in
Computer Engineering at SVERI’s COE (Polytechnic), Pandharpur during the academic year 2024-2025 .
(Ms. M.B.Patil )
Guide
(Mr. P. S. Bhandare) (Dr. N. D. Misal)
HOD Principal
Place: Pandharpur
Date: / /
Acknowledgement
“Restaurant Management System” has been developed successfully with a great contribution of
four students in a period of two months. We like to appreciate their guidance, encouragement and
willingness since without their support the project would not have been a success. We would like to give
our heartfelt gratitude to Principal Dr. N.D. Misal , HOD Mr. P. S. Bhandare & Guide Ms. V. B. Maskar
who is the supervisor of our project for helping and encouraging us in many ways to make our project a
success. We would never been able to finish our work without great support and enthusiasm from friends
and support from our family. We would like to thank the department of Computer Engineering, for giving
us permission to initiate this project and successfully finish it.
Restaurant Management System
1. Rationale:
Restaurant management is the managing restaurant to improve productivity . It is essential to manage
restaurant effectively to avoid ensure timely responses, and stay organized.
Restaurant management systems are software solutions that help users manage their restaurant more
efficiently. The rationale behind using an restaurant management system is to streamline the process of
managing restaurant.
2. Aim/Benefits of the Micro-project:
Restaurant management systems are designed to help individuals and organizations manage their
restaurant in a more efficient and productive manner.
Benefits of restaurant management systems:
1. More time-efficient
2. Higher profits with better restaurant management
3. Better productivity
4. Better work-life balance
5. More focused work
3. Course Outcomes Achieved:
Design E-R diagram and create normalized database on given data
4. Literature Review
A literature review on Restaurant Management System (RMS) is a comprehensive study of the existing
literature on the topic. It aims to identify, analyze, and synthesize the existing knowledge on RMS .Efforts
have been made to continually improve these systems.
5. Actual Methodology Followed:
Schema:-
desg
emp_id c_id
1 M
restro Works
emp
in
1 emp_id
salary
Visit
emp_name
total Bill
cust
O_name
O_id
c_id c_name
6. Output of Micro-Project:
Emp-id Emp-name Salary Designation
1 Sonakshi 50000 Manager
2 Amit 30000 Chef
3 Simran 15000 Waiter
4 Sneha 10000 Dish-washer
5 Prachi 10000 Cleaner
Fig. for emp
cid cname oid oname totalb
ill
1 Shruti 1111 Samosa 25
5 Vanshika 1131 Pizza 180
2 Keshav 1211 Noodles 80
3 Mrunali 1231 Burger 99.5
1 Shruti 1311 Cold coffee 50
4 Ketki 1321 Chicken Biryani 250
7 Shreya 1341 ChickenCurry 450
6 Kranti 1421 Mutton Curry 500
2 Keshav 1431 Manchurian 80
5 Vanshika 1631 Burger 150.5
5 Vanshika 1931 Coffee 100.5
Fig. for cust
Emp_id C_id
1 1
1 5
5 3
5 2
5 1
3 2
3 4
3 2
3 1
3 6
2 1|
2 2
2 4
Fig.for restro
7. Queries
Query’s For Emp:-
mysql> create database rmsystem;
Query OK, 1 row affected (0.02 sec)
mysql> use rmsystem;
Database changed
mysql> create table emp(empid int primary key,empname varchar(20),salary float,deptname varchar(20));
Query OK, 0 rows affected (0.07 sec)
mysql> create table cust(cid int,cname varchar(20),oid int primary key,oname varchar(30),totalbill float);
Query OK, 0 rows affected (0.09 sec)
mysql> create table restro(empid int references emp(empid),cid int references cust(cid));
Query OK, 0 rows affected (0.07 sec)
mysql> alter table emp add column desg varchar(20);
Query OK, 0 rows affected (0.05 sec)
Records: 0 Duplicates: 0 Warnings: 0
mysql> alter table emp drop column deptname;
Query OK, 0 rows affected (0.04 sec)
Records: 0 Duplicates: 0 Warnings: 0
mysql> select*from emp;
Empty set (0.01 sec)
mysql> insert into emp values(1,'Sonakshi',50000,'Manager');
Query OK, 1 row affected (0.02 sec)
Query’s For Cust :-
mysql> insert into cust values(1,'Shruti',1111,'Samosa',25.00);
Query OK, 1 row affected (0.01 sec)
mysql> insert into cust values(2,'Keshav',1211,'Noodles',80.00);
Query OK, 1 row affected (0.02 sec)
mysql> select*from cust;
Query’s For Restro :-
Mysql> insert into restro values(1,1);
Query OK, 1 row affected (0.01 sec)
mysql> insert into restro values(1,5);
Query OK, 1 row affected (0.02 sec)
mysql> select*from restro
Queries :-
select cname,sum(totalbill)from cust group by cname;
select cname,sum(totalbill)from cust group by cname having sum(totalbill)>400;
select empname from emp where empid IN(select empid from restro where cid=5);
select empname from emp where empid IN(select empid from restro where cid=2);
select empname from emp where empid IN(select empid from restro where cid=3);
select empname from emp where empid IN(select empid from restro where cid=1);
8. Actual Resource Used:
Sr. No Name of Recourse Specification Qty Remark
RAM: 8GB
1 Laptop Processor: i5 1
HDD: 1TB
Graphic: 2GB
2
MySQL/ Maria DB Version 10.4.6 1
9. Skill Developed/Learning outcome of Micro-Project:
The Restaurant Management System benefits are time-efficiency means to save time that is usually
wasted, organizing important information becomes easier, allowing you to stay focused on essential work
higher profits and better productivity.
10. Application of this Micro-Project:
1. Employee Support : These systems aid in handling internal communication and inquiries.
2. Sales : Restaurant management software streamlines communication with leads and prospects.
3. Marketing : For managing restaurant campaigns and feedback.
4. Human Resources : Useful for employee inquiries.
11. Conclusion:
The Restaurant management is the process of managing restaurant with help of database to improve
productivity.It reflects the relation between a restaurant ,employeeand customer
References:
https://www.javatpoint.com/dml-commands-in-sql
https://www.tutorialspoint.com/what-are-the-dml-commands-in-dbms
