Database Management System

4. Answer the questions considering the following case -

Yummy-Best-East Burger is currently in need of creating a database for their food items and customer profiling. At present, they sell Beef and Chicken burgers along with Pizzas. To increase the sale, the cafeteria owner wants to run a loyalty program for its customers so that they can not only track the sales but also send promotional offers. There are three types of staff - Manager, Salesperson and Chef. (a) Identified database tables and populate with sample data, which Normal form it is in? [2] (b) Transform your initial tables to 3rd Normal form. Show all the steps [3] (Note: You are allowed to have necessary assumptions for the above scenario.)