A
PROJECT REPORT ON
“DINE RESERVE”
Submitted in partial fulfilment of requirements for the award of degree of
BACHELOR OF TECHNOLOGY
in
Computer Engineering
by
1. Prajwal Kute 2110121245062
2. Adarsh Tiwari 2110121245054
3. Shruti Ratnparkhi 2110121245058
Under the Guidance of
Prof. J. A. Zade Mam
Department of Computer Engineering
Government College of Engineering, Yavatmal
2022-2023
Department of Computer Engineering
Government College of Engineering, Yavatmal
(An Institute of Government of Maharashtra)
CERTIFICATE
This is to certify that the Project report entitled
“ Dine Reserve ”
is a bonafide project work and has been carried out by team:
Prajwal Kute ( 2110121245062)
Adarsh Tiwari (2110121245054)
Shruti Ratnparkhi (2110121245058)
of Third Year B-Tech class under the guidance of Prof. J. A. Zade during the academic year
2023 -2024 (Sem-V).
Prof. J. A. Zade Prof. C. V. Andhare
Project Guide Head, Computer Department
Dr. P. M. Khodke
Principal
Department of Computer Engineering
Government College of Engineering, Yavatmal
(An Institute of Government of Maharashtra)
This is to certify that the Project report entitled
“Dine Reserve”
is a bonafide project work submitted by:
Prajwal Kute ( 2110121245062)
Adarsh Tiwari (2110121245054)
Shruti Ratnparkhi (2110121245058
in partial fulfilment for the award of degree of bachelor of technology In Computer
Engineering.
Prof. J. A. Zade Prof. C. V. Andhare
Project Guide Head, Computer Department
Internal Examiner External Examiner
Sr.No INDEX Page No
CHAPTER 1
1 Introduction
1.1 Background
1.2 Objective
CHAPTER 2
2 System Planning
2.1 Use of technologies
2.2 Stakeholders
2.3 Requirement Specification
CHAPTER 3
3 System Design
3.1 User Interface Design
CHAPTER 4
4 System Testing
4.1 Unit Testing
4.2 Integrated Testing
CHAPTER 5
5 Conclusion
CHAPTER 6
6 References
Chapter - 1
1.INTRODUCTION
Dine Reserve is the online website which is used or create to improve the quality and
time wasting in table booking in the restaurant field.
In many popular restaurants, waiters/waitresses tend to miss out on
tables or customers’ calls during busy hours potentially decreasing ones
clientele. While this is an ongoing issue, there is still no product that drastically
improves the communication between the servers and the customers in the
current market. Hence, the goal is to design a system in which the customers
can call their servers easily and help the restaurant increase overall efficiency.
An internal wired communication system will allow prompt notification to the
server when a customer requires service. Moreover, servers can also be more
focused on serving their current customers and save their time and energy
from always keeping an eye out for needy customers. On top of meeting the
needs of customers, restaurant managers can also monitor the response time
of their waiters/waitresses through use of this system. Hardworking, proficient
employees will become more recognized while lazy, inefficient employees
become motivated to improve. As a result, the restaurant becomes more
efficient and possibly increasing morale while improving the level of customer
satisfaction.
1.1 BACKGROUND
Customer satisfaction is the key to success for any business. In a
restaurant, the traditional hand-waving method for calling services
is inefficient often leading to many complaints. The Restaurant Management
System increases operational efficiency through use of an internal wired
communications system. The communications system increases customer
satisfaction by leaving a system at each table which the customer can use to
request for a server. This system allows managers and owners to easily monitor
restaurant functions and employee progress. In many popular restaurants,
waiters/waitresses tend to miss out on tables or customers’ calls during busy
hours potentially decreasing ones clientele. While this is an ongoing issue,
there is still no product that drastically improves the communication between
the servers and the customers in the current market. Hence, the goal is to
design a system in which the customers can call their servers easily and help
the restaurant increase overall efficiency.
1.2 OBJECTIVE
In todays fast moving word out to make people even more
convenience on any aspects. Restaurant Management System provide an
system based food ordering system without help of a waiter. It
involves seller and buyer which could bring benefits to each other. It is
win-win situation that will bring benefits to the world. This system was
bringing a convenience for customer that can make order by help of a
computer. It provides customer with a completely new way to make
order. By providing customer convenience and also increase the sales.
No time wasted with order taking or letting the customer browse the
menu over the system. This system provides more reliable usability,
maintainability and dependability functions. By creating quality, easy to
keep track management of new system. So that it can streamline all the
works by a simple click. By develop the system based food ordering
system can reduce the unnecessary costs such as staff salaries, customer
satisfaction, reputation, etc. Our restaurant also easy to keep track for
the maintenance and point redumption.
CHAPTER – 2
2.SYSTEM PLANNING
2.1 USE OF TECHNOLOGIES
1) Front End -:
HTML - Hypertext Markup Language (HTML) is the standard markup language for documents designed
to be displayed in a web browser. It can be assisted by technologies such as Cascading Style Sheets (CSS) and
scripting languages such as JavaScript.
Web browsers receive HTML documents from a web server or from local storage and render the
documents into multimedia web pages. HTML describes the structure of a web page semantically and originally
included cues for the appearance of the document.
HTML elements are the building blocks of HTML pages. With HTML constructs, images and other
objects such as interactive forms may be embedded into the rendered page. HTML provides a means to create
structured documents by denoting structural semantics for text such as headings, paragraphs, lists, links, quotes and
other items.HTML elements are delineated by tags, written using angle brackets. Tags such as and directly introduce
content into the page. Other tags such as surround and provide information about document text and may include
other tags as sub-elements. Browsers do not display the HTML tags, but use them to interpret the content of the
page.
HTML can embed programs written in a scripting language such as JavaScript, which affects the behavior
and content of web pages. Inclusion of CSS defines the look and layout of content. The World Wide Web
Consortium (W3C), former maintainer of the HTML and current maintainer of the CSS standards, has encouraged
the use of CSS over explicit presentational HTML since 1997
CSS –
Cascading Style Sheets (CSS) is a style sheet language used for describing the presentation of a document
written in a markup language such as HTML. CSS is a cornerstone technology of the World Wide Web, alongside
HTML and JavaScript.
CSS is designed to enable the separation of presentation and content, including layout, colors, and fonts.
This separation can improve content accessibility, provide more flexibility and control in the specification of
presentation characteristics, enable multiple web pages to share formatting by specifying the relevant CSS in a
separate .css file which reduces complexity and repetition in the structural content as well as enabling the .css file to
be cached to improve the page load speed between the pages that share the file and its formatting.
Separation of formatting and content also makes it feasible to present the same markup page in different
styles for different rendering methods, such as on-screen, in print, by voice (via speech-based browser or screen
reader), and on Braille-based tactile devices. CSS also has rules for alternate formatting if the content is accessed on
a mobile device.
The name cascading comes from the specified priority scheme to determine which style rule applies if
more than one rule matches a particular element. This cascading priority scheme is predictable.
The CSS specifications are maintained by the World Wide Web Consortium (W3C). Internet media type
(MIME type) text/css is registered for use with CSS by RFC 2318 (March 1998). The W3C operates a free CSS
validation service for CSS documents
JavaScript (JS)
Is a lightweight, interpreted, or just-in-time compiled programming language with first-class functions.
While it is most well-known as the scripting language for Web pages, many non-browser environments also use it,
such as Node.js, Apache CouchDB and Adobe Acrobat. JavaScript is a prototype-based, multi-paradigm, single-
threaded, dynamic language, supporting object-oriented, imperative, and declarative (e.g. functional programming)
style.
JavaScript runs on the client side of the web, which can be used to design / program how the web pages
behave on the occurrence of an event. JavaScript is an easy to learn and also powerful scripting language, widely
used for controlling web page behavior.
JavaScript is not "Interpreted Java". In a nutshell, JavaScript is a dynamic scripting language supporting
prototype based object construction. The basic syntax is intentionally similar to both Java and C++ to reduce the
number of new concepts required to learn the language. Language constructs, such as if statements, for and while
loops, and switch and try ... catch blocks function the same as in these languages (or nearly so).
JavaScript can function as both a procedural and an object oriented language. Objects are created
programmatically in JavaScript, by attaching methods and properties to otherwise empty objects at run time, as
opposed to the syntactic class definitions common in compiled languages like C++ and Java. Once an object has
been constructed it can be used as a blueprint (or prototype) for creating similar objects
2) Back End :-
SQL
SQL is a short-form of the structured query language, and it is pronounced as S-Q-L or sometimes as See-
Quell.
This database language is mainly designed for maintaining the data in relational database management
systems. It is a special tool used by data professionals for handling structured data (data which is stored in the form
of tables). It is also designed for stream processing in RDSMS.
You can easily create and manipulate the database, access and modify the table rows and columns, etc.
This query language became the standard of ANSI in the year of 1986 and ISO in the year of 1987.
If you want to get a job in the field of data science, then it is the most important query language to learn.
Big enterprises like Facebook, Instagram, and LinkedIn, use SQL for storing the data in the back-end.
"A Relational Model of Data for Large Shared Data Banks" was a paper which was published by the great
computer scientist "E.F. Codd" in 1970.
The IBM researchers Raymond Boyce and Donald Chamberlin originally developed the SEQUEL
(Structured English Query Language) after learning from the paper given by E.F. Codd. They both developed the
SQL at the San Jose Research laboratory of IBM Corporation in 1970.
At the end of the 1970s, relational software Inc. developed their own first SQL using the concepts of E.F.
Codd, Raymond Boyce, and Donald Chamberlin. This SQL was totally based on RDBMS. Relational Software Inc.,
which is now known as Oracle Corporation, introduced the Oracle V2 in June 1979, which is the first
implementation of SQL language. This Oracle V2 version operates on VAX computers.
2.2 STAKEHOLDERS
1. App Onboarding
This feature includes registration, authentication and user profile creation. In the user profile section,
the user should to register on the website dine reserve all the essential information like his name, id , food
order menue , number of customer and the time slot for the food o. In this section, you should take
information from the user regarding his preferences to envision and provide him best service according to
his/her desires
2. Food List
In this feature customer can see which food is available in the restarunt and which food customer like .
they can see all that information with their price int mainu section.
3.Order Section
In this Section customer can order the slot booking for a particular table with its
desired food on the favourable time so that when he want food then can directly go in the
restarunt and enjoy the food.
4.Payment Gateway
This feature is added for the restarunt use when the customer order the food and if we
don’t take the money first then may be there are some chances that the customer may not
go on that time then there is waste of food and t6ime, money of restarent.
Also it gives may options to customer to pay without cash.
5.Contact Us
What could be a better option than giving your users a platform where they can order the table at a
restarunt a list of all their preferred foodin a single spot.
This feature gives an option to take the help of the community for any querry.
.
2.3 Requirement Specification –
Software Requirement
Software Requirement for this system are as follows:
FRONT END Html5, CSS , JavaScript
BACK END SQL, PHP
OPERATING SYSTEM Windows 11
2.4 Devlop Management
DEVELOP MANAGEMENT PROGRAMMING LANGUAGE PHP: Hypertext Preprocessor PHP is a
server-side scripting language designed for web development but also used as a general-
purpose programming language. PHP is now installed on more than 244 million websites and
2.1 million web servers. Originally created by Rasmus Lerdorf in 1995, the reference
implementation of PHP is now produced by The PHP Group. While PHP originally stood for
Personal Home Page, it now stands for PHP: Hypertext Preprocessor, a recursive acronym.
PHP code is interpreted by a web server with a PHP processor module which generates the
resulting web page: PHP commands can be embedded directly into an HTML source
document rather than calling an external file to process data. It has also evolved to include a
command-line interface capability and can be used in standalone graphical applications. PHP
is free software released under the PHP License, which is incompatible with the GNU
General Public License (GPL) due to restrictions on the usage of the term PHP. PHP can be
deployed on most web server DATABASE MySQL MySQL is the most popular database
system used with PHP. What is MySQL? • MySQL is a database system used on the web •
MySQL is a database system that runs on a server • MySQL is ideal for both small and large
applications • MySQL is very fast, reliable, and easy to use • MySQL supports standard SQL •
MySQL compiles on a number of platforms • MySQL is free to download and use • MySQL is
developed, distributed, and supported by Oracle Corporation • MySQL is named after co-
founder Monty Widenius's daughter lOMoARcPSD|20430937 Restaurent Management
System 14 DEPARTMENT OF COMPUTER HARDWARE MAINTENANCE The data in MySQL is
stored in tables. A table is a collection of related data, and it consists of columns and rows.
DEVELOPMENT SOFTWARE Macromedia Dreamweaver 8 Macromedia Dreamweaver 8 is a
professional HTML editor for designing, coding, and developing websites, web pages, and
web applications. Whether you enjoy the control of hand-coding HTML, or prefer to work in
a visual editing environment, Dreamweaver provides you with helpful tools to enhance your
web creation experience. This guide introduces you to using Macromedia Dreamweaver 8 if
you’re unfamiliar with any major aspect of it. The tutorials in this guide lead you through the
process of creating a simple but functional website. The visual editing features in
Dreamweaver let you quickly create web pages without writing a line of code. You can view
all your site elements or assets and drag them from an easy-to-use panel directly into a
document. You can streamline your development workflow by creating and editing images in
Macromedia Fireworks or another graphics application, and then import them directly into
Dreamweaver. Dreamweaver also provides tools that make it easy to add Flash assets to web
pages. In addition to drag-and-drop features that help you build web pages, Dreamweaver
provides a full-featured coding environment that includes codeediting tools (such as code
coloring, tag completion, a coding toolbar, and code collapse) and language reference
material on Cascading Style Sheets (CSS), JavaScript, ColdFusion Markup Language (CFML),
and other languages. Macromedia Roundtrip HTML technology imports your hand-coded
HTML documents without reformatting the code; you can then reformat code with your
preferred formatting style. Dreamweaver also lets you build dynamic, database-driven web
applications using server technologies such as CFML, ASP.NET, ASP, JSP, and PHP. If your
preference is for working with XML data, Dreamweaver provides tools that let you easily
create XSLT pages, attach XML files, and display XML data on your web pages. Dreamweaver
is lOMoARcPSD|20430937 Restaurent Management System 15 DEPARTMENT OF COMPUTER
HARDWARE MAINTENANCE customizable. You can create your own objects and commands,
modify keyboard shortcuts, and even write JavaScript code to extend Dreamweaver
capabilities with new behaviors, Property inspectors, and site reports. Notepad++ Notepad+
+ is a free source code editor and notepad replacement that support several languages.
Running in the MS windows environment, Its use is governed by GPL license. Based on a
powerful editing component scintilla. Notepad++ is written in C++ and uses pure win32 API
and SLT which ensure a higher execution speed and smaller program size. Notepad is a full
featured text editor with features like syntax high lighting and syntax folding like HTML,ASP,JAVA,CSS
and PHP etc. Firefox/Google Chrome Firefox and Google Chrome is used to testing the web pages.
And both browsers are used to search for more information to do this project.
CHAPTER – 3
3. SYSTEM DESIGN
3.1 User Interface Design
For giving the order, the user should become a member initially. User would have to
install Restaurent Management System 6 DEPARTMENT OF COMPUTER HARDWARE
MAINTENANCE key information so that he doesn’t have to give his information each
time. For signing up every customer has to give some this details such as address,
name, Contact no etc and the most important is email ID which is the primary key to
identify each customer uniquely, thus email becomes the User ID for the customer.
The only thing needed here is to sign in to the system through the system. Now he
would have the option to edit his current information and big thing to order the food
diminishing the human interaction. He would have today’s menu in front of him and
he have the clear choices for order. He has variety of things to do here and have the
option to cancel the order before the serving. For the first time to access the system,
customer has to give his key information like identification and so on. For the
management side, it is quite possible to book many orders concurrently. System will
be able to book nearly infinite number of orders at a time. Management side has
more updated information and they can get the currently orders. System will be able
to deal with the customers who don’t come to take there orders by blocking them
and not letting them to signup again. This is done by maintaining some information
regarding the status of order and the relative customer. So according to that the
system can deal him. How system deals with him..? He should have to pay the
amount of the last order in order to continue with his membership. All that would be
implemented in Apache Server Pages and MySQl Servlets. At Login page we will be
checking the user’s existence and mapping his user ID/email ID with his password, if
the user is valid then he is allowed to access further) lOMoARcPSD|20430937
Restaurent Management System 7 DEPARTMENT OF COMPUTER HARDWARE
MAINTENANCE At Registration, it is checked that the user ID/ email ID is not
preexistening, along with various general events/acts such as the customer had
entered right format of the e-mail, or it is not entered NIL, all phone & mobile
numbers contain only the numbers, etc. The option of password reminder is also
included, so that when the user forgets his password then he can get a new password
by giving his email ID, only if he already exists!!
CHAPTER – 4
4. SYSTEM TESTING
4.1 Unit Testing
It is a level of software testing where individual units/ components of a software are tested. The purpose is
to validate that each unit of the software performs as designed. A unit is the smallest testable part of any software. It
usually has one or a few inputs and usually a single output. In procedural programming, a unit may be an individual
program, function, procedure, etc. In object-oriented programming, the smallest unit is a method, which may belong
to a base/ super class, abstract class or derived/ child class. (Some treat a module of an application as a unit. This is
to be discouraged as there will probably be many individual units within that module.) Unit testing frameworks,
drivers, stubs, and mock/ fake objects are used to assist in unit testing. Unit Testing is the first level of software
testing and is performed prior to Integration Testing. It is normally performed by software developers themselves or
their peers. In rare cases, it may also be performed by independent software testers.
4.2 Integrated Testing
INTEGRATION TESTING is a level of software testing where individual units are combined and tested as
a group. The purpose of this level of testing is to expose faults in the interaction between integrated units. Test
drivers and test stubs are used to assist in Integration Testing. Any of Black Box Testing, White Box Testing and
Gray Box Testing methods can be used. Normally, the method depends on your definition of ‘unit’.
CHAPTER – 5
CONCLUSION
The purpose of the wireless restaurant management system is to improve worker
efficiency and to maximize profit margin of restaurant owners by providing better service.
Providing prompt response to customers through use of a System and data collection by the
Main Dispatcher will allow this to happen. This project proved to be a larger task than
expected due to lack of manpower and late arriving parts. Certain functionality also had to be
abandoned to meet time constraints. The System is not designed to replace the existing
ordering systems which are at many restaurants but to complement it. Once the Restaurant
Management System becomes further refined with the ideas discussed in the previous
section, it will pose to be an indispensable tool.
It means it give access to save the precious time in this modern word where money is
less important than the time.
FUTURE DEVELOPMENTS The main dispatcher system software may have a few areas
to improve on in the future. The current system allows anyone to view and modify the
database. Adding a user profiles with password will improve the overall security of the
system. As for eccentric feature, colour code different request status, request type, or waiter
id would make the request table easier to read. In the future, it would be efficient to join this
main dispatcher software to the existing ordering software that restaurants use today to
increase the productivity
CHAPTER – 6
REFERENCES
I would like to thank Professor. Jaya . A. ZADE, our professor for the project guidance
year 2023
References that helped me building this website:
www.google.com
www.wikipedia.com
Active expert software B. V.2010 http://www.activexpert.com/xmstoolkit/howto/
http://www.dynamicdrive.dynamicindex3/snow.com.htm
