The project is in the picture

ignCandy(1).pdf CS 2500 Elementary School Candy Sales Database Design Problem The following table is an attempt to track the sale of candy by elementary school students. The sale money for a school trip. Each class could have several students attempting to sell candy have received. Each student is given several units of candy (QtyR), and the amount of each that have sold is recorded (QtyS). The system is to track the running total of candy received and old. 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. ndy2 Chocolate Chocolate A Crisp Chocolate Chocolate Chocolate dwards, Linda 5th-A our Worms Almond Chocolate Chocolate Final Project will consist of the following 1. An Entity Relationship diagram representing the database design showing all necessary 2. Conversion of E-R diagram into table structures with appropriate fields, primary and foreign 3. Data manipulation statements using data manipulation language (DML) to populate tables 4. All tables normalized in third normal form entities and their relationships keys and field types. This will be turned in as data definition statements using data definition language (DDL) with data from the case study Two examples of SQL statements to retrieve data from related tables 5. Do more with Microsoft Edge-the fast, new browser built for Windows 10. Change my default Don't ask again O Type here to searcth bockspoce 8 0 M