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 2Answer
a.
Create Entity/Table Customer and use CustomerID vs. Customer name
b.
Add OrderQty column and remove TotalOrderAmount
c.
Create Entity/Table OrderType and use OrderTypeID vs. OrderType name
d.
Create Entity/Table 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 blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!