After you have applied the Third Normal form to your database, the student shall upload to Blackboard their E-R diagram with the entities, attributes 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. QtyR3 Qty S3 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, AI 5th-B Almond Chocolate Bell, Carol 6th-A Milk Chocolate QtyR1 Qtys1 Candy2 5 Crisp Chocolate 3 Crisp Chocolate 4 Crisp Chocolate 3 Sour Worms 5 Milk Chocolate wooo QtyR2Qtys2Candy3 5 5 Sour Worms 8 6 5 Sour Worms 4 Crisp Chocolate