ONLINE RESTAURANT MANAGEMENT SYSTEM

People prefer restaurant for food due to their hectic schedule and busy life. They don’t even want to visit restaurant because of the shortage of time therefore they need a system which will help them in placing the order for food and delivering it at their door step. The system is explainable with the help of this relational model in which different entities and attributes are used to showcase the transfer of data from one entity to another within the system. The whole process is managed by the admin, he is the sole responsible for all the activities of the system. The flow of data into the system is stored in the database which will be elaborated by the entities below:

  1.  Admin:

The system is managed by the admin, he also helps in sustaining the accounts of other users who are a part of the system in order to make sure that is system work continuously without any error. With the help of this entity, the admin can manage his account and control all the other activities of the system. The admin power is considered to be the greatest power in the system which can be delegated to more than one person if the system works on a larger scale not able to be managed by a single person then after the admin power is administered to many persons. The attributes of this entity are defined below:

• Admin_ID:  Unique Identity Number attached with every admin account to help them in verifying their accounts and maintaining their personal detail within it.
• Name: The official name of each admin person according to their documents is saved in this attribute.
• Contact No.: Admin is the head entity and therefore he can be contact by any person at any point of time, his contact number is saved in this attribute.
• Email Address:  The email address of each admin saved in this attribute to be connected by other users.
• Gender: The gender biasness will be bifurcated when the system updates the policy about it with the help of this attribute.

  2. Stock:

The restaurant needs to fulfill the requirement of the stock to make the dishes demanded by the customer. The inventory of the restaurant is always needed to be check by the superior authorities in order to maintain the stock up to optimum level.  The raw material is the main things which are required to make the dishes demanded by the customer.  this entity maintain the account of the stock in which it includes the quantity and details of each and every product along with the shortage which is going on right now in the inventory which will be helpful in purchasing more stock. The related attributes are defined below:

• Stock_ID: An identity number is attached with the type of stock which is purchased by the owner for the inventory.
• Product Name: There are so many types of the product available in the stock therefore their names should be mentioned in this attribute.
• Serial No.: Every product which is purchased by the owner will include a serial number provided by the factory outlet.
• Quantity:  It is also very necessary to check the number of quantity available for each stock.
• Shortage: The employees also maintain record of the products which are in shortage in the inventory.
• Inventory In: This Attribute holds the detail of the date on which the inventory has come into the premises.

3. Restaurant:

System is helpful for many restaurant therefore there are so many restaurants which are attached with the system and carrying out the services provided by the system. The system maintains different accounts for each restaurant. In this account, it is stores the details of each restaurant including the details of the owner, restaurant address and staff detail also. It is very important for the system to contain the database of each restaurant in a regular basis to provide a sustainable help to each restaurant owner. Regular check is done to update the policies of the restaurant if they have updated any. The related attributes are defined below:

• Restaurant_ID: Identity Number is attached with each restaurant account to enhance their security.
• Name: The name of each restaurant which is registered in the Food Corporation is saved in this attribute.
• Contact No.: Official number of each restaurant is also provided through this attribute for connection purpose.
• Email Address: Email address of the restaurant is also provided to the customer if they want to send any query for feedback.
• Address: The exact location along with the nearby landmark is saved in this attribute.
• Owner’s Details:  Every restaurant is owned by a person whose details are collected in this attribute.

   4. Waiter:

The restaurant is managed by the waiters who are working there. They manage the upper level managers along with the customers who visit the restaurant and provide them valuable services. The waiters need to create an account in this system to get the benefit. The system provides a simple and secure account making for each waiter in which the waiter can get easy access to his details along with the number of customer he has attended and the orders he has taken in a particular day. The system also helps the waiter in maintaining the everyday work in order to send our report to the manager periodically. The related attributes are defined below:

• Waiter_ID: Each waiter will get an identity number provided by the system for their accounts.
• Name: The name of each waiter need to be saved in this attribute according to the documents provided by them.
• Contact No.:  Every waiter’s contact number is saved in this attribute for connection purpose by the managers.
• Email Address: Each waiter also provides their email address which will be helpful for getting any update by the restaurant management.
• Shift: The waiters work in a particular shift decided by the management which will be sometimes rotational for every week.
• Residence: The permanent address of each waiter needed to be saved in this address for authentication of each waiter.

   5. Order:

Customer provides order according to the type of the food they want to eat through the menu provided by the restaurant. Restaurant take their order to prepare food and deliver to their home or else they go to the restaurant for dining in. every order contains the detail of the  customer who has booked the particular order along with the details of the payment if it is done by the customer or not. The system helps in bifurcating the order which will be helpful for the waiters to manage the system properly and deliver the orders of each customer within time limit. The related attributes are defined below:

• Order_ID: The order given by the customer contains an identity number attached by the system randomly.
• Items: This attribute contains the details of the items choose by the customer in the particular order for preparation.
• Customer’s Details: The details of the customer are also saved in this attribute who has booked the particular order.
• Payment: This attribute holds the detail of the payment done by the customer either in cash or online through the system.
• Order Details: This attribute contains the other related detail provided by the customer including is special instruction for a particular dish.

   6. Customer:

The orders to prepare dishes to the restaurant are provided by the customers as per their interest and taste. The system creates an account for each customer in which the customer feed their personal details. The customer can see their recent order along with the order history they have done till now. The system also provides payment option, which can be done by the customer with the help of their account or else he can choose for cash on delivery option.  The customer can also edit their detail after accessing their account and can book multiple orders at the same time. The related attributes are defined below:

• Customer_ID: Every customer is provided an identity number by the system in order to help them in accessing their account.
• Name: The name of the customer provided by them is saved in this attribute.
• Contact No.:  It is very important for the customer to provide their contact number along with the order which is saved in this attribute.
• Email Address: The customer provide their email address to the restaurant on which they get the details of their order and payment.
• Residence: The customer sometime wants order to be delivered at his home therefore he needs to provide his permanent address.
• Current Order: This attribute saves the data of current order which is selected by the customer in the system.
• Payment: This attribute holds the detail of the payment done by the customer either through online mode or cash on delivery.