Database Design Problem The following table is an attempt to track the sale of candy by elementary school students. The sale is to raise money for a school trip. Each class could have several students attempting to sell candy they have received. Each student is given several units of candy (QtyR), and the amount of each that they have sold is recorded (QtyS). The system is to track the running total of candy received and sold. Individual allocations and sales of candy do not need to be recorded. Note that the sample data within the table shown below is an un-normalized, flat-file system. tyR1 QtyS1 Candy2 tyR3 QtyS:3 Class Candy1 5th-A tyR2QtyS2/Candy3 Student Smith, Joe Blaha, Mike 5th-A Milk Chocolate Edwards, Linda 5th-A Parks, Ann Frankin, A 5th-B Chocolate 5Crisp Chocolate r Worms 4 Chocolate 6 d Chocolate Chocolate r Worms 4Crisp Chocolate 3Sour Worms 5Milk Chocolate 4 5th-B 4 Chocolate 4Crisp Chocolate l, Carol Final Project will consist of the following An Entity Relationship diagram representing the database design showing all necessary entities and their relationships Conversion of E-R diagram into table structures with appropriate fields, primary and foreign keys and field types. This will be turned in as data definition statements using data definition language (DDL) Data manipulation statements using data manipulation language (DML) to populate tables with data from the case study All tables normalized in third normal form Two examples of SQL statements to retrieve data from related tables 1. 2. 3. 4. 5