The aim of this project is to create a Restaurant Management Database (RMD) is an online application for restaurant management. This system wakes to provide service facilities to restaurants and to the customer. The services which are provided are food ordering, reservation of the table by the customer through the system online, menu information management, and report.
The main goal of this project is to make the customers satisfied to get the food from anywhere
- To develop the online ordering and reservation system in restaurants.
- To develop a user interface for an online restaurant management system to provide online menu information for customers to order
Project requirement
The basic requirement is to make the customers log in and order their favorite food online. To do so they need to look at the menu. Thus, there must be a menu with quantity and price options. Thus, these basic requirements are addressed for now.
Mission statement
The objective is to help the customer to order food online and get them delivered through an interactive application.
Objectives
- The application should support customer registration
- Registered customers should gain access through username and password
- There must be an interactive menu with all details
- Customers should be allowed to browse the menu
- Customers can place an order by adding the menu item to the cart.
Interview Questions
- What tables are needed for the system?
- How will we ensure that there are no duplicate records in the database?
- How will the customer know whether the item is available or not?
- What navigational options are good for customers?
- How do secure customer payment information and personal information?
ER Diagram
Tables
|
Product ID |
Product name |
Details |
Status |
Price |
|
Int |
char |
char |
char |
Currency |
|
user_id |
username |
password |
address |
mobileno |
email id |
|
int |
char |
varchar |
varchar |
number |
varchar |
|
cart_id |
user_id |
product details |
product_id |
quantity |
price |
|
int |
int |
char |
int |
int |
currency |
|
delivery_id |
user_id |
delviery status |
duedate & time |
|
int |
int |
varchar |
date time |
|
Reservation_id |
User_id |
Name |
date |
table choice |
time |
|
int |
int |
Varchar |
date |
int |
time |
Output Results:
Admin Dashboard:
All Orders Details Page:
Restaurant Management Table booking Admin Page:
Popular Dishes Page:
Here you can freely download the complete Restaurant Management System project Source code with both MySQL and MSAccess database code, User Manual Report.