Restaurant Management System Database Project using PHP, MySQL/MS Access

The aim of this project is to create a Restaurant Management Database (RMD) is an online application to restaurant management. This system wakes to provide service facility to restaurant and to the customer. The services which are provided is 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 restaurant.
  • To develop use interface for online restaurant management system to provide online menu information for customer to order

Project requirement

The basic requirement is to make the customer login and order their favourite food online. To do so they need to look at the menu. Thus, there must be a menu with quantity and price option. Thus, these basic requirements are addressed for now.

Mission statement

The objective is to help the customer to order food online and get them deliver 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
  • Customer should be allowed to browse the menu
  • Customer can place order by adding the menu item to 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 customer know whether the item is available or not?
  • What navigational options are good for customer?
  • How to 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:

 

About admin

Check Also

Python Projects on Machine Learning, Deep Learning and Artificial Intelligence

These are the below Python Projects on Machine Learning, Deep Learning, Artificial Intelligence, Big Data, …

Leave a Reply

Your email address will not be published.