Database for a Food Franchise

You have been asked to design a called FreshBurgersNow which currently has 10 outlets scattered across Scotland. The database proposed is one to cover a specific part of their ordering and employee systems.

So it must importantly contain a list of the orders taken, this is based on the customers placing an order, however only registered customers are able to make an order either one telephone or app connection. The order is then passed to the kitchen area (i.e. cooks) who will make the various items and package them ready for delivery. Finally the drivers will deliver these orders to the customer’s home address. The franchise is unique in that it does not take over the counter orders, and only concentrates on deliveries to its current database of customers.

When first registering the customer needs to provide the usual amount of personal information (e.g. name, address, email, mobile number etc.). Customers are also able to receive various promotional information via an email shot by the company that occurs every 2-3 months, this is based on a special menu that is devised by the local manager.

The staff that work for FBN also provide a similar amount of information when they start at the franchise, along with the various training courses they have completed and skill set they possess. Certain information concerning the staff employment status is also kept e.g. the National Insurance number, scanned copy of their passport and a scanned copy of their driving licence (for drivers). The various employees can be either given a role as a driver, cook, order staff or shift-leader, these are entered into the system and updated when necessary. Also some details about the basic pay rate for each member of staff will be kept on the system.

One part of the system is so the owner of the franchise can identify which member of staff takes the most orders and what are the most popular orders taken. The owner wants to track if the customer has made their payment by either cash or card. The owner 3

 can then collate this information for all the outlets, and determine which of the outlets is performing best (and of course which needs to improve its performance).

There are two menus that the customer can chose from — the regular menu and the savers menu. All of the products sold should either be on the regular menu or on the savers menu. The regular menu has a breakfast section that finishes at 11am each day. The savers menu has a start and end date and is changed monthly. For example in December they will have a festive savers menu.