Attached Below

2. Following tables are part of the information system Checkers Pizza uses to track its home delivery business. Define table names to be intuitive, e.g., CUSTOMER, ORDER, PIZZA, TOPPING, etc. CustID Name Address City State Zip Phone C1001 Lucinda Philip 123 Elm Road Elmhurst NJ 07802 (908) 678-0987 C1037 William Hurd 78 Wright Drive Appleton NJ 07930 (908) 776-8823 C1104 Yu-Ran Chen 90 Wright Drive Appleton NJ 07930 (908) 223-0904 Cl161 Mohan Singh 211 Jones Court Eastville NI 08023 (732) 778-7023 OrderNum Date CustID PieNum Size ToppingCode ToppingDescrip 7348 11/10/10 C1001 Large PRI Pepperoni 7348 11/10/10 C1001 Small GAR Garlic 7349 11/10/10 C1104 Large 7350 11/10/10 C1161 Large MUSH Mushroom 7350 11/10/10 C1161 Large PEP Peppers 7350 11/10/10 C1161 Large ART Artichoke hearts 8001 11/11/10 C1037 Small SAU Sausage 8001 11/11/10 C1037 Small MUSH Mushroom 8001 11/11/10 C1037 Small GAR Garlic 8001 11/11/10 C1037 Large 8052 11/12/10 C1001 Large SAU Sausage 8052 11/12/10 C1001 Large EXC Extra cheese 8052 11/12/10 C1001 Small GAR Garlic The interpretation of the data shown is as follows: . On November 10, Lucinda Philip placed an order for a large pepperoni pizza (PieNum = 1) and a small garlic pizza (PieNum = 2). . On November 10, Yu-Ran Chen ordered a large plain pizza (with no toppings). Note that the PieNum field is only unique within a given order; thus, the first (and only) pizza in this order also has PieNum = 1. . On November 10, Mohan Singh ordered a large mushroom and peppers pizza (two toppings on the same pizza, with PieNum = 1), along with a large artichoke hearts pizza (PieNum = 2). For this order, note that the lines with MUSH and PEP both have attribute PieNum equal to 1, meaning they are both for the first pizza in the order. . On November 11, William Hurd ordered a small sausage, mushroom, and garlic pizza (three toppings on the same pizza - again, note there are multiple lines with the same value for PieNum), and a large plain pizza. . On November 12, Lucinda Philip placed another order, this time for three pizzas: a large sausage, a large extra cheese, and a small garlic. Design a third-normal-form database storing the same information as the above two tables. Draw an ER diagram and write a database design outline. You may add "ID" fields wherever necessary. This is a relatively challenging problem, so please read the above interpretation of the data carefully and clearly understand it before normalization. (30 points)