1. [12 pt.] (general) Normalize each database design of the following problems 1) A sales representative in a book publishing company takes replenishment orders from retailers and has been storing the order information in an Excel worksheet as follows (only a sample of rows is shown): Quantit OrderID OrderDate Supplier 5/10/2018 BookTitle asy Sushi log Wild Over Ham ptown Books 10 nic Wicnie 15/2018 5/25/2018 Cabba 002 mania ptown Books ew Vegetarian Vegetables ad Kill Cookin 004
OR
OR