Question
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
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.)
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started