Question: What should be done to normalize this table? Select All that Apply Question 2 Answer a . Create Entity / Table Customer and use CustomerID
What should be done to normalize this table?
Select All that Apply
Question Answer
a
Create EntityTable Customer and use CustomerID vs Customer name
b
Add OrderQty column and remove TotalOrderAmount
c
Create EntityTable OrderType and use OrderTypeID vs OrderType name
d
Create EntityTable Item and use ItemID vs MenuItem name
e
We don't need to normalize, it's good to have all information together
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
