Need help!!

After you have applied the Third Normal form to your database, the student shall upload to Blackboard their E-R diagram with the entities, attribures relationships, primary and foreign keys for the course project as a result of the data normalization process.

The E-R diagrams can be drawn with a drawing application such as Microsoft VISIO and the file uploaded to Blackboard. If the student does not have access to a drawing application the student can hand draw the diagram and send a scanned or digitally photographed picture of the drawings. If you photograph your work, the entire diagram must be visible and readable

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 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. Q tyR3 Qtys3 QtyR2 Qty S2 Candy3 5 5 Sour Worms Student Class Candy1 Smith, Joe 5th-A Almond Chocolate Blaha, Mike 5th-A Milk Chocolate Edwards, Linda 5th-A Almond Chocolate Parks, Ann 5th-B Crisp Chocolate Frankin, Al 5th-B Almond Chocolate Bell, Carol 6th-A Milk Chocolate QtyR1 Qty S1 Candy2 5Crisp Chocolate 3 Crisp Chocolate 4 Crisp Chocolate 3 Sour Worms 5 Milk Chocolate 5 Sour Worms 4Crisp Chocolate ate Final Project will consist of the following: 1. An Entity Relationship diagram representing the database design showing all necessary entities and their relationships 2. 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) 3. Data manipulation statements using data manipulation language (DML) to populate tables with data from the case study. 4. All tables normalized in third normal form 5. Two examples of SQL statements to retrieve data from related tables