Restaurent management system

Restaurant Management System
Developed By:- Smit Patel & Prince Patel
WEB BUCKET INFOTECH 1

INDEX
Introduction
Project Profile
Company Profile
Tools & Technology
Existing System
Problem in existing System
Advantages
ER – Diagram
Data Flow Diagram
Data Dictionary
Screen Layout
Report Layout
Bibliography

1. PROJECT NAME : RESTAURANT MANAGEMENT SYSTEM
2. ORGANIZATION : RAJA PUROHIT RESTAURANT
3. SOFTWARE USED : VB.NET 2005 (FRONT END)
with Frame Work 2.0
MS SQL SERVER 2005 EXPRESS
EDITION (BACK END).
4. DOCUMENTATION
TOOL : MS OFFICE 2007
5. DROWING TOOL : MS Visio 2007
PROJECT PROFILE
BackWEB BUCKET INFOTECH 3

COMPANY PROFILE
Back
Hotel Name RAJA PUROHIT RESTAURANT
Hotel Address Raja Purohit Restaurant,
At Ghadhinagar-mansa highway,
Radheja crossroad,
Gandhinagar
Hotel Phone No 9998641415
Hotel Work Restaurant Management System
Hotel Symbol

PROJECT DEFINITION
Back
 The user can see different types of reports, which
displays all the details of customers, food bills, customer
receipts etc.
 So these are the normal process of the organization
and how each and every process is done in the company
that is shows in the project.
Purpose of required system is to provide all details of
 sales ,
 order ,
 events ,
 bill
 employees.

TOOLS & TECHNOLOGY
HARDWARE REQUIREMENTS:
• 256 MB RAM
• At least 2 GB Hard Disk
• Pentium processor
SOFTWARE REQUIREMENTS:
• Framework 2.0
• SQL Server 2005 Express Edition
• Windows xp Higher Version of Windows

EXISTING SYSTEM
Semi Manual
Every business process is on paper
Every business information generated by Employee

PROBLEM IN EXISTING SYSTEM
Time consuming
Looking for a particular information in various criteria is
inefficient
System lack secured environment

ADVANTAGES OF RESTAURANT
MANAGEMENT SYSTEM
Security
Easily
Search
All the
required
Reports
Data
consistency

ER Diagram

Data Flow Diagram
0 LEVEL

DATA FLOW DIAGRAM :-
0 level diagram
Entity Description
Customer: - used to provide order of food items
Admin : - define all food menu details
Employee: - used to get various order details and generate sales
bill details

1. LEVEL

2. LEVEL

Data Dictionary

Column Name Data
Type
Size Description Constraint
Category_Id Numeric (2, 0) Id of the
category.
Primery key
Category_Description Varchar (20) Foods of
category
Not null
1. Category_Details

2. FoodItems_Details
Column Name Data
Type
FoodItem_Id numeric (5, 0) Id of the FoodItem. Primary Key
FoodItem_Name Varchar (30) Name of FoodItem. Not null
Category_Id numeric (5,0) Id of the Category. Not null
Rate numeric (2) Rate of Item. Not null
Offer Varchar (20) Offer Not null
Notes Varchar (50) Any Notes
Is_jain Yes/No FoodItem is Isjain or
not
Spicy Varchar (6) High / Medium / Simple Not null

Column Name Data
Type
Item_Id numeric (3,0) Id of the Item. Primery key
Item_Name Varchar (20) One fooditem
contain many
items
Not null
3. Item_Master

Column Name Data
Type
Emp_Id numeric (2, 0) Id of the Employee. Primary
Key
Name Varchar (20) Name of the Employee. Not null
Designation Varchar (15) Employee Designation. Not null
Work_Type Varchar (10) Type of Employee Work.
(Part time or Full time)
Not null
Address Varchar (50) Address of Employee
Area Varchar (10) Employee Area Not null
City Varchar (10) Employee City Not null
State Varchar (10) Employee state Not null
PinCode Varchar (6) Employee’s City Pin code Not null
Phone_No Varchar (12) Phone no of the Employee
Mobile_No Varchar (10) Mobile no of the
Employee
Salary numeric (5, 0) Salary of the Employee. Not null
4. Emp_Details

Column Name Data
Type
Table _Id numeric (2,0) Id of the Table Master Primary key
TableCapacity Varchar (30) Capecity of customer in
one table
Not null
Emp_Id numeric (2,0) Id of the Employee Foreign key
5. Table_master

Column
Name
Data
Type
Customer_Id numeric (5, 0) Id of the Customer Primary Key
Name Varchar (20) Customer Name Not null
Address Varchar (30) Address of Customer Not null
Area Varchar (10) Customer area Not null
City Varchar (10) Customer City Not null
Pincode Varchar (6) Customer’s City Pin code Not null
Phone_No Varchar (12) Phone no of the Customer
Mobile_No Varchar (10) Mobile no of the Customer
Email_Id Varchar (30) Customer’s Email Id
Notes Varchar (50) Any Notes
6. Customer_Information

Column Name Data
Type
Order_Id Numeric (5,0) Id of the Order. Primary key
Orderdate Datetime - Date of the Order Not null
Table_Id Numeric (2,0) Id of the Table
Master
Foreign key
Emp_Id Numeric (2,0) Id of the Employee Foreign key
7. Order_Details

Column Name Data
Type
OrderItem_Id Numeric (5,0) Id of the OrderItems primary key
Order_Id Numeric (5,0) Id of the Order. Foreign key
FoodItem_Id Numeric (3,0) Id of the Food Items Foreign key
Quantity Numeric (3,0) Quantity of the
OrderItems
Not null
Rate_Per_Items numeric (2) Rate of the
OrderItems
Not null
Amount numeric (5) Amount Not null
8. Order_Items

Column Name Data
Type
Salesbill_No Numeric (5,0) Id of the Salesbill. Primary key
Salesbilldate Varchar (15) Date of the Salesbill Not null
Order_Id Datetime - Id of the Order Foreign key
Customer_Id Numeric (5,0) Id of the Customer Foreign key
Amount Numeric (5) Total amount Not null
Tax Nmeric (3) Tax Not null
Discount Numeric (3) Discount Not null
Net_Amount Numeric (5) Net amount Not null
9. Salesbill

Column Name Data
Type
Billitems_Id Numeric (5,0) Id of the BillItem primary key
Salesbill_No Numeric (5,0) Id of the Salesbill Foreign key
Fooditem_Id Numeric (5,0) Id of the FoodItem Foreign key
Quantity Numeric (3,0) Quantity of the
BillItems
Not null
Rate_Per_Items numeric (2) Rate of the BillItems Not null
Amount numeric (5) Amount Not null
10. Bill_FoodItems

Column Name Data
Type
Payment_Id Numeric (5,0) Id of the Payment primary key
Order_Id Numeric (5,0) Id of the Order Foreign key
Customer_Id Numeric (5,0) Id of the Customer Foreign key
Paid_Amount numeric (6) amount Not null
Paid_Mode Varchar (10) Cash
Credit card
Check
Not null
CreditCardNo Numeric (16,0) Credit card No
CheckNo Numeric (5,0) Check No
BankName Varchar (10) Bank Name
Branch Varchar (10) Branch name
11. Payment_Collection

Column Name Data
Type
FoodItem_Id numeric (5,0) Id of the
FoodItem.
Composite
key
Item_Id numeric (5,0) Id of the Item.
12. FoodItem_Item

Column Name Data
Type
Login_Id Numeric (2, 0) Id of the User Primary Key
Login_Name Varchar (10) Name of the User. Not null
Login_Password Varchar (15) Password Of the User. Not null
Login_Type Bit - Type of the login
(admin or and user)
Not null
Created_Date Datetime - Date of the Created
login
Not null
Allowed_Login Varchar (5) Allowing login or not Not null
13. Login_Details

Column Name Data
Type
History_Id Numeric (5,0) Id of the User Primary Key
Login_Id Varchar (2,0) Name of the User. Foreign Key
LoginDatetime Datetime - Date of the Created
login
Not null
Logoutdatetime datetime - Date of the Logout
time
Not null
14. Login_History

Screen Layouts

Reports Layouts

Google
MSDN
VB.NET BLACK BOOK
Bibliography

THANK YOU

Restaurent management system

Recommended

Recommended

More Related Content

What's hot

What's hot (20)

Similar to Restaurent management system

Similar to Restaurent management system (20)

More from Smit Patel

More from Smit Patel (12)

Recently uploaded

Recently uploaded (20)

Restaurent management system