Apply normalization (1NF, 2NF and 3NF) of the system description given below and justify why relation needs 1NF, 2NF, and 3NF or not. At the end shift normalized data into Un-Normalized Data.                               

System Description: 

Fast-food Order Management System

A System that allows customers to put orders using Wi-Fi with following features:

a)            View Menu (With time to prepare)

b)            Choose items and quantity from menu

c)            Confirm Order

d)            Add more items in order

e)            Delete Items from List

f)             Table Location of customer

g)            Comments management

h)            Packing for home Option

i)             Special offers from Company

j)             Cancel Oder if not items not ready in specified time

solve all steps complete and show all parts

Answer rating: 100% (QA)

Normalization is the process of organizing the data in the database Normalization is used to minimiz... View the full answer