MIS 372: Data Management Homework 3 Normalization Homework (10 Points) Pine Valley Furniture Company would like to create a small database to keep track of customers and orders. They have provided you with an example report and business rules for the database. You need to use the information provided to normalize the report to tables in third normal form. Business Rules: 1. Each order has a unique order number 2. An order specifies an order date, a customer id, a customer name, and a customer address 3. A customer's name and address can be identified by the customer id 4. An order contains one or many products 5. Each product has a unique product id, which specifies the product description, finish, and price 6. The combination of order id and product id specify the quantity of a product ordered Tasks: Using normalization (hint: I have been having you do this all along but see chapter 8 in the textbook), draw the logical data model, then create a small database for Pine Valley Furniture Company (the data model and database should be normalized to third normal form). Populate the tables with the data from the report above. Deliverables: A file containing the data model drawn and the SQL used to create and populate the tables in SQL Server