A Database Design for Pre-ordering System Based on Prediction of Customer Arrival Time

Abstract

Recently, with a busy lifestyle of the people, we can witness that majority of them spend a long waiting time in lines of the restaurants and take-out coffee shops. As modern people should solve many problems in a limited time, systems that takes the pre-orders at the restaurants and take-out coffee shops are necessary. However, currently there is a small number of systems that efficiently support the pre-order services. In this paper, taking into consideration that smartphone services have become an integral part of the modern people’s life, we propose a database design for mobile based pre-order system. The proposed system effectively uses the customer’s history and efficiently handles the pre-orders. Specifically, in this paper we propose a database design to predict the customer’s arrival time based on customer’s past experience. By using our system, modern people can reduce the wasting of unnecessary time at the restaurants and take-out coffee shops. Moreover, the proposed database design can serve as a blueprint for other pre-ordering systems in the future.