Database tables for restaurant management system

17 Restaurant DBMS 3 Restaurant DBMS 4 Initial Study Kentucky Fried Chicken was started back in the year 1930. The founder of the restaurant was known as Coronel Harland. It is commonly known through its abbreviation, KFC. In 1991, the restaurant adopted the use of its abbreviation, KFC, from the complete words, Kentucky Fried Chicken. However, the restaurant began using its full name again in 2007. The name proceeded to be used during the branding and other activities of the restaurant such as advertising. The restaurant is the largest dealer of fast chicken food products globally. The main types of foods served by Kentucky Fried Chicken restaurant are inclusive of salads, wraps, burgers, and pieces among others. Although it majors on the fried chicken products, the restaurant also serves the roasted chicken products, desserts, and sides (Wirtz and Lovelock 2018). It also deals in the products that are not sourced from the chicken as their raw material. Some of such products are sourced from the beef and pork meat. Products obtained from such raw materials are inclusive of kebabs and burgers (Rahman 2019). This work, therefore, is geared towards drawing a report of a database management system of the Kentucky Fried Chicken restaurant. The main items contained in the menu list of Kentucky Fried Chicken are chicken, coleslaw, sides, desserts, burgers, and kebabs among others. The customers served by the restaurant are diversified regarding their social classes and regions of residence. The restaurant is situated in over eighty countries globally to enable it to reach as many customers as possible. The products are also prepared to favor the preferences of the customers. Mainly, it involves fast food types (Mondurailingam Jeyaseelan and Subramani 2015, pg.50-62). The restaurant employs the use of a database management system to make control orders from the customers, the purchases made, and the consumption of raw materials among others (Rahman 2019). Restaurant DBMS 5 Requirements analysis This project is aimed at controlling the transactions that are carried out by the restaurant. It is aimed at making the businesses of the restaurant safe by reducing the losses that may accrue from poor management of data and misappropriation of information. It takes care of the information circulation among the staff members and the between them and their customers. It is also meant to put the billing system under sufficient control. The generation of the bills of the restaurant may be lead to great errors if not put under control. Therefore, there is need to come to employ a Bus system that that facilitates adequate preservation and transfer of data within the restaurant (Dignös et al. 2016, pg.26). Such a Bus system should be made to have the maximum access and control of every transaction done by the restaurant. The database includes the details of the products that are provided by Kentucky Fried Chicken, its staff members, address, type of services offered, types of customers, and the detail that lead the customers in making their choices and the placing orders for the goods of their choice. Also, it should include the specifications of the addresses of the customers who may need the restaurant to deliver their orders at their homes or areas of residence. The customers visiting the restaurant at its locations may also need to specify the areas that they wish to occupy while taking their meals. Through the database management system, the customers of Kentucky Fried Chicken can access the services of the restaurant through the use of the internet. However, it will require them to create a portal that subscribes them to the system of the restaurant. Hence, they can access the services of the restaurant any time in their comfort zones to reduce the traveling expenses. They can place their orders through pages online pages accessible after signing up. When the customers are placing their orders, they are required by the system to make specification regarding their Restaurant DBMS 6 details, the location of the restaurant I case they wish to visit in person, the time they wish to get served, their age, gender,