Restaurant database example

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.