e5c8febf-e7de-4456-80fd-a0c83321a364.pptx

Restaurant database management system

1. RESTAURANT DATABASE MANAGEMENT SYSTEM Under supervision of: DR. Aditya Kumar Gupta Associate professor (Department of computer science ) Submitted By: Abhishek kumar Aayush Ranjan Yuvraj Singh Prafull kumar

2. Table of Contents Introduction Objective Purpose Feasibility Study System Analysis Proposed system Hardware / Software Requirements 0 Level DFD 1 Level DFD E-R Diagram

3. INTRODUCTION This restaurant management system can be used by employees in a restaurant to handle the clients, their orders and can help them easily find free tables. The restaurant menu is organized by categories ( appetizers,soups , salads, entrees, sides and drinks) of menu items. Each menu item has a name, price and associated recipe. A recipe for a menu item has a chef, preparation instructions and associated ingredients. Restaurant management system is the system for management for the restaurant business. Restaurant management can vary across multiple management styles, however, there is always one common denominator when it comes to setting goals: maximizing a restaurant’s profitability. In order to maximize a restaurant’s feasibility, one has to always examine and understand a restaurant’s operational costs and how these relate to a restaurant’s productivity and efficiency in delivering quality service to its customers.

4. Management takes a very important role in controlling and manipulating the balance of costs and profitability. An effective manager must always concern himself/herself with restaurant issues that pertain to inventory/stocking, pricing, order taking, and much more. Oftentimes, a restaurant’s profitability either rises or falls depending on how well it is being managed. Managing a restaurant using a well developed software minimizes the liabilities of mismanagement and productivity loopholes. The incorporation of a Restaurant Management Software in the managing of various business processes entails that your restaurant is competitive, innovative, well managed, and upto date with the latest management and business trends.

5. OBJECTIVE The objective of this project is to develop a database system in such a way that restaurant can get accurate details of online ordering through web application so customer get a notification if the order is ready for pickup and customer can track the order if he/she orders online This will require the use of text file to store data in order to read and write in it. Its employees file management to store data like as order, payment, token number and all the data related to restaurant. The website may show order, payment history, token number and so on. The source code is comprehensive devoid of error and simple to comprehends One of the main objectives of the project is to reduce the number of programs for a single work (like remove program to input data, as it uses file handling). The delivery boy has unique DB id in which the history of the delivery boy will be stored, and every delivery boy has unique address id. The delivery boy must deliver food in his given address only no one can deliver outside his area.

6. PURPOSE The main objective is to maximize the profit by increasing efficient and decreasing the mistakes that takes place in the kitchen, this will be done without compromising customer satisfaction. At this moment of time, there are still numerous restaurants that still use paper based system to get messages across between the restaurant and the kitchen, this way of communication is one of th e least efficient method. However, this approach may be implemented and designed in a successful profitable restaurant but there are numerous problems which might be seen as reducing the restaurants efficiency, they are the following: The lack of communication that is caused by handwriting. Uncontrolled order logging (poor order taking). Unproductive communication between restaurant and kitchen. Faults with order taking and lack of time management. Lack of good quality stock management. Limited statistical output. So, in order to overcome these problems, we have made an application that is restaurant management system that mainly focuses on the above given problems. We have tried to build a User friendly interface.

7. FEASIBILITY STUDY Feasibility is the study of impact, which happens in the organisation by the development of a system. The impact can be either positive or negative. The feasibility study can be performed in two ways: Technical Feasibility : We can strongly say that it is technically feasible, since there will not be much difficulty in getting required resources for the development and maintaining the system as well. All the resources needed for the development of the software as well as the maintenance of the same is available in the organisation here we are utilising the resources which are available already. Operational Feasibility: This system is a small restaurant information and food ordering management system, which needs small amount of resources. Any computer can meet the conditions both in hardware and software, therefore, this system is feasible in operation. 

8. SYSTEM ANALYSIS System Analysis is a detailed study of the various operations performed by a system and their relationships within and outside of the system. Here the key question is- what all problems exist in the present system? What must be done to solve the problem? Existing System In the existing system, we need to keep a number of records related to the customer and the details of the customers are entered manually. In the system, only the admin can alter the customer details which cause overload to the authorities. This is time consuming and has much cost. Modifying customer information is a broad process which can lead to confusion

9. PROPOSED SYSTEM In our proposed system, we have the provision for adding the details of the customers by  themselves, so the overhead of the restaurant authorities and the supplier is become less. Another advantage of the system is that it is very easy to edit the details of the customer and delete a customer when it found unnecessary. As each customer will have a particular id, passwords by which they can access the basic information, it will also display all the activities on the dashboard of customers and the admin will have the authority to add, update features and disable it as per their requirements. By developing the system we can attain the following features : Easy to handle                                       Provide a proper guidelines  User friendly interface  Easy to use and feasible  Comfortable Time management

10. HARDWARE / SOFTWARE REQUIREMENTS HARDWARE REQUIREMENT Processor : core i3(or higher) Memory : 2 GB or above Cache Memory : 128 kb or above Backup : Pen drive Pen drive : 32 GB Hard Disk : 50 GB or above SOFTWARE REQUIREMENT Web server : Apache UI Technology : HTML,CSS Database :MySQL Client Side Scripting : Java Script Server Side Scripting : PHP

11. O LEVEL DFD

12. 1 LEVEL DFD

13. ER DIAGRAM

14. THANK YOU!