Database Question

1. Table is in 2NF

Select ALL that apply

a. Not in 2NF, CustomerName doesn't depend on OrderID b. Not in 2NF , MenuItem and OrderType don't depend on OrderID c. It is in 2NF d. Not in 2NF, TotalOrderAmount may depend on OrderQty (not shown)

2.What should be done to normalize this table?

Select All that Apply

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

Order