Institute of Computer Studies
Colegio De Montalban
Rodriguez, Rizal
Restaurant Reservation System
Group 9
Leader: Belchez, Jhon Paul
Balcuba, Kenneth
Enriquez, John Roi
Jargue, Rachelle
Institute of Computer Studies
Colegio De Montalban
Rodriguez, Rizal
Chapter 1
Introduction
Technology has improved every aspect of our life, from networking and healthcare to
communication and transportation. The finest thing is that it always improves by
enabling more sophisticated functions. For instance, facetime and instant messaging
have come a long way from conventional voice calls.
REPUBLIC ACT NO. 11360, August 07, 2019
AN ACT PROVIDING THAT SERVICE CHARGES COLLECTED BY
HOTELS, RESTAURANTS AND OTHER SIMILAR ESTABLISHMENTS BE
DISTRIBUTED IN FULL TO ALL COVERED EMPLOYEES, AMENDING FOR
THE PURPOSE PRESIDENTIAL DECREE NO. 442, AS AMENDED,
OTHERWISE KNOWN AS THE "LABOR CODE OF THE PHILIPPINES"
To optimize the number of reservations they receive, restaurants have adopted a
variety of the number of covers for that restaurant. Systematic use of online
reservations has made it simple to manage their reservations and design a table
layout unique to their establishment, as well as the arrangement of the tables for
serving. The decision's outcome is a reservation. Yet, getting there requires
understanding the importance of an online reservation system first. As a result, this
study explores how visitors think about making pre-purchase decisions. It assesses
the Considering the overall system's efficiency to all visitors and how purchase
selections were made within related to the restaurant business by other industries.
Institute of Computer Studies
Colegio De Montalban
Rodriguez, Rizal
Project Context
This project's primary goal is to provide the software for managing restaurants that is
simple to use to control the client. Additionally, assisting the clients can order from
their homes or places of employment a location that offers both food delivery and the
option to order meals from the restaurant and have it delivered. The upkeep of this
Android app is your responsibility. the wait staff, food choices, costs, payments, and
orders. The ultimate goal is to bring together all the classes of restaurants to one
platform for all of the smaller establishments restaurants, including upscale eateries.
This application is helpful for hurried planning.
The current approach requires physical labor for everything. pen and paper, either
by the waitstaff or the managers based processes that additionally result in the
waste of inks as well as paper. Here, the current system uses Reservations for
tables that must be made either by calling the restaurant either at the front desk or
on foot to the restaurant. It results in time being wasted if the table is not at the time
of the visit. In order to make a convenient reservation, we employed an email
module. By obtaining the reserver's email, we may determine whether or not they
are active.
Institute of Computer Studies
Colegio De Montalban
Rodriguez, Rizal
Purpose and Description
Particularly in recent years, people have become accustomed to making
appointments and placing orders online. Therefore, it is already predicted that
restaurants and other food-related enterprises would have adapted to a method of
integrating online and digital solutions into their operations. Let's go through a few
advantages of using a restaurant reservation system both during and after the
pandemic.
Reservations generally assist your restaurant in better managing the flow of
customers into your location. Additionally, it enables you to monitor the number of
seats available in your facility at any one time. A restaurant reservation system can
help you manage your restaurant reservations more effectively.
A software program that assists your clients in making reservations for meals is
known as a restaurant reservation system. You may easily handle stated eating
bookings on your end thanks to a restaurant reservation system. A restaurant
reservation system can already be integrated with a website for a business today.
Your restaurant can effectively keep track of how many tables are available at any
given time thanks to the reservation system. Additionally, you may better serve your
clients and guests with the system.
Your business may keep track of customers who have booked reservations using
the reservation system. Additionally, if that particular person cancels, the reservation
system will inform you. As a result, you can offer the table seats right away to more
prospective guests.
Institute of Computer Studies
Colegio De Montalban
Rodriguez, Rizal
Objectives
The general objective of the proposed system which is “Restaurant Reservation
System” is to help lessen one of the worst issues facing the industry, no-show
customers. Empty seats are never a pleasant sight, especially for restaurants with
thin profit margins. Additionally, it might be upsetting for these establishments to turn
away consumers due to incorrect reservations or a lack of available tables. Allows
customers complete flexibility to make reservations without any contact and gives
restaurants the chance to manage tables effectively. Online reservations also reduce
waiting time because of queue management tools.
Specific Objectives are:
● Better idea of how busy a night will be.
-Taking reservations will offer proprietors a clearer indication of how busy or
quiet their nights will be. It is unknown whether a restaurant will see a dinner
rush with open tables.
● Prepare chefs for a rush.
-Chefs and kitchen staff, on the other hand, will have fair warning to be ready
for an oncoming rush at a given time if the reservation schedule indicates that
they will be packed.
● Reduce waiting time.
-Reservations at a restaurant are advantageous to the proprietor and the
culinary staff as well as improving the quality of the dining experience for the
patrons.
Institute of Computer Studies
Colegio De Montalban
Rodriguez, Rizal
Scope and Limitations
This study primarily concentrated on delivering retailing business applications using
computerized systems that allow businesses to track services and strive to give
precise and dependable processes on every transaction, particularly in a restaurant
reservation. This study investigated how technology use nowadays is affecting our
daily lives, particularly for consumers. With the use of this research, we can better
inform and educate our beneficiaries about the distinctions between the current
digital generation and manual systems.
Its robust restaurant reservation, marketing, and merchandising features enable you
to distribute confidential trade rates, offer varying rates and commissions,
accommodate multiple seasons, distribute last-minute rates, accept multiple
currencies, including the euro, and much more. Restaurant Reservation System is
designed to manage all types of restaurant bookings made directly by customers.
Without the need for an expensive web designer, the restaurant reservation system
will let you dynamically control the majority of your restaurant reservations.
Institute of Computer Studies
Colegio De Montalban
Rodriguez, Rizal
Technical Background
Data Flow:
1. Make Reservation: The consumer makes the first request for a reservation by
indicating their choices (such as the date, time, number of guests, etc.).
2. Reservation Management: This procedure receives the reservation request,
verifies the information provided, and records the reservation information in the
Reservation Database.
3. Reservation Confirmation: The consumer receives a confirmation message when
the reservation is made successfully.
4. Restaurant Management: The restaurant management procedure checks the
Reservation Database on a regular basis for new reservations and adjusts the
table availability as necessary.
5. Manage Restaurant Profile: Information that is kept in the Restaurant Database
about the restaurant, such as its operation schedule and profile, may be updated
during the restaurant administration process.
Entity Relationship
Customer: Represents the customer entity who makes reservations.
● customer_id: Unique identifier for each customer.
● name: Name of the customer.
● email: Email address of the customer.
● phone_number: Contact number of the customer.
Reservation: Represents the reservation entity.
● reservation_id: Unique identifier for each reservation.
● customer_id: Foreign key referencing the customer who made the reservation.
● restaurant_id: Foreign key referencing the restaurant for which the reservation is
made.
● date: Date of the reservation.
● time: Time of the reservation.
Restaurant: Represents the restaurant entity.
● restaurant_id: Unique identifier for each restaurant.
● name: Name of the restaurant.
● address: Address of the restaurant.
● cuisine_type: Type of cuisine offered by the restaurant.
● capacity: Maximum seating capacity of the restaurant.
Table: Represents the table entity within a restaurant.
● table_id: Unique identifier for each table.
● restaurant_id: Foreign key referencing the restaurant to which the table belongs.
● capacity: Seating capacity of the table.
Institute of Computer Studies
Colegio De Montalban
Rodriguez, Rizal
Definition of Terms
The following terms are operationally defined to enable the readers to a better
understanding and more comprehensive knowledge on this study.
Computerized System is an electronic device or a group of hardware and software
components that performs logical, arithmetical, and memory functions by manipulations
of electronic or magnetic impulses.
Email is the exchange of computer-stored messages from one user to one or more
recipients via the internet.
Online connected to, served by, or available through a system and especially a
computer or telecommunications system (such as the Internet) an online database.
Restaurant a place where people pay to sit and eat meals that are cooked and served
on the premises.
Reservation an arrangement to have something (such as a hotel room) held for one's
use.
Software Program is a set of instructions, data or programs used to operate
computers and execute specific tasks
System a set of things working together as parts of a mechanism or an interconnecting
network.
Technology is the application of scientific knowledge to the practical aims of human
life or, as it is sometimes phrased, to the change and manipulation of the human
environment.
Web Designer creates the layout and design of a website. In simple terms, a website
designer makes a site look good.
Institute of Computer Studies
Colegio De Montalban
Rodriguez, Rizal
Chapter 2
REVIEW OF RELATED SYSTEMS
Online Table Booking and Food Ordering System (Akshay Magnani, Jitesh Tilwani
and Mrs. Suvarna Hazare) (2017)
According to (Akshay Magnani, Jitesh Tilwani and Mrs. Suvarna Hazare. 2017)
The widespread development of mobile devices and wireless technologies is having a
significant impact on our lives. Early attempts to combine and exploit both of these
technologies to advance industry have been made. This study intends to streamline the
online ordering of food and reservations for tables in restaurants. This system is more
affordable and effective than multi-touchable restaurant management systems, and it
successfully addresses the shortcomings of earlier PDA-based food ordering systems.
The user can choose food items from the menu that is displayed using this system. The
user places the food order. Both online and pay-on-delivery payment methods are
available. The restaurant owner has little trouble managing menu changes.
Restaurant Booking and Ordering System (Shrideep Pujari, S. Rawool,
Prof.Vaishali Bodade)(2017)
Since it is an Android application, I will try to keep the idea of the restaurant table order
management system as straightforward as possible. The project is an Android app that
customers may use to book their preferred timing and table number. The owner
oversees the web portal, which is used to review reservations and display availability for
customers. This system awakens to give restaurants and customer service facilities.
The services offered include meal ordering, table reservation management, waiter
information management, administration of customer and waiter information,
management of menu information, and report generation. The primary goal is to offer
the consumer ordering and reservation services.
Table Booking and Restaurant Management System Using Android Application(B.
Naveen Kumar, B. Sai Varun)(2020)
According to (B. Naveen Kumar, B. Sai Varun2020), The users of this Android
application project can make a table reservation at a particular restaurant and
flexibility of date and time, in addition to placing the food is immediately followed by
a table reservation, here the moment when the individual arrives and accepts the
order will be saved, and ordering the allows the user to cuisine prepared at home
with the possibility of takeout simply accessing their laptops or mobile phones from
any location in conjunction with internet connectivity.
Institute of Computer Studies
Colegio De Montalban
Rodriguez, Rizal
Chapter 3
Operational Framework
The Waterfall Approach was the first commonly used SDLC Model in software
engineering to ensure project success. The entire software development process is
split into distinct phases using "The Waterfall" technique. In a waterfall model,
normally, the results of one phase serve as the sequential input for the next phase.
The following diagrammatic illustration of the various waterfall model stages
Phases of a Waterfall Model
The following phases are ordered in the waterfall model:
In the first phase, Gathering and analyzing requirements: Every system
requirement that might possibly be throughout this phase are recorded and detailed
in a requirement specification document.
In the second phase, System Design: In this phase, the first phase's required
specifications are examined.system design has been created. System Design aids
in defining hardware and system requirements. As well as determining general
system architecture, it aids in identifying requirements.
In the third phase, Implementation: The system is initially created in small pieces
with input from the system design. Unit-based programs are incorporated in the next
stage. Each component is created and Unit testing is the process of evaluating a
piece of software for functioning.
In the fourth phase, Integration and testing: Following the testing of each unit
created during the implementation phase, the entire system is integrated. The entire
system is tested for errors and failures after integration.
In the fifth phase, System deployment: After functional and non-functional testing,
the product is put into use by customers or published onto the market.
In the sixth phase, Maintenance: Occasionally, problems in the client environment
arise. Patches are published to address certain problems. Additionally, improved
versions of the product are issued. To bring about these changes in the
surroundings of the consumer, maintenance is performed. The progression is
perceived as flowing slowly downward (like a waterfall) through the phases as all of
these phases are connected to one another. After the previous phase has
concluded, the
The "Waterfall Model" got its name because each phase's goals were clearly stated
and were met before it was approved. Phases in this model don't cross over.
Figure 1
An Operational Framework showing the Development of Restaurant
Reservation System
Institute of Computer Studies
Colegio De Montalban
Rodriguez, Rizal
Requirements Specification
In systems engineering and software engineering, requirements analysis refers to the
processes involved in identifying the demands or conditions that must be satisfied for a
new or modified project, taking into account the potentially conflicting demands of the
various stakeholders, and analyzing, documenting, validating, and managing software
or system requirements.
Our system is compatible with Linux OS and other platforms as well as Windows XP,
Windows 7, and Windows 8 with 32-bit and 64-bit operating systems. A 486/66 MHz or
faster processor with 8 MB is required for machines running Windows XP. A faster
processor with 2 GB of RAM is required for machines running Windows 7 and Windows
8.
In making our system we used a Visual Basic. Net for the front end, and for our
database we used a MySQL DBMS. Hardware recommended by all required software,
including RAM of at least 256 MB and a hard drive of at least 10 GB.
Institute of Computer Studies
Colegio De Montalban
Rodriguez, Rizal
Conceptual Framework
A framework for describing how information flows through a system is called the
Input-Process-Output (IPO) model. A system is divided into three parts: input, process,
and output. The IPO model can be used to improve a restaurant reservation system in
the following ways:
Input
- Customer reservation requests: Information from customers includes the preferred
day, time, number of guests, any special requirements, and their contact information.
Table status and availability information is provided from the system database or
administration interface for the specified date and time.
Processes
- Availability check: The system examines the availability of tables for the requested
date and time before processing the customer's reservation request. To evaluate if a
table can be assigned, it checks the desired parameters with the available inventory of
tables.
- Table assignment: If a table is available, the system will allocate a good one based on
the number of people in the party and any other specifications the customer has
provided.
- Waitlist management: If there are no open tables, the system may give consumers the
option to join a waitlist and manage the waitlist appropriately, notifying customers when
a table opens up.
Output
- Reservation confirmation: If a table assignment is successful, the system creates a
reservation confirmation that contains information like the reservation ID, date, time,
number of guests, and any specific instructions.
- Waitlist notification: Should a customer's name be added to a waitlist, the system may
send them a notification recognizing their request and informing them of their place on
the queue.
- Updated table availability: After a reservation is accepted or canceled, the system
modifies the table availability in the management interface or database to reflect the
most recent development.
It's important to note that this is a condensed illustration of a restaurant reservation
system's input, procedures, and output. Based on particular requirements and system
features, the actual implementation may involve additional complications and stages.
Figure 2
A Conceptual Framework showing the development of Restaurant Reservation System
