You are designing a database for an e-commerce business that sells athletic shoes online. Your business purchases shoes wholesale from major manufacturers like Nike and Adidas and resells them to consumers. Your target market consists of long-distance runners who do 5K and 10K races and marathons. Through your website, you specialize in helping each runner find the best shoe for his or her individual performance level and running style. What entities would a database for this business need to include? What are some business rules that would apply to these entities, and how would they be reflected in the database design? What are the stages in developing a data model for a database design? What new information and refinements are added to the model at each stage?

Write a grading program for a class with the following grading policies: a. there are two quizzes, each graded on the basis of 10 points. b. there is one midterm exam and one final exam, each graded on the basis of 100 points. c. the final exam counts for 50% of the grade, the midterm counts for 25%, and the two quizzes together count for a total of 25%. (do not forget to normalize the quiz scores. they should be converted to a percentage before they are averaged in.) any grade of 90 or more is an a, any grade of 80 or more (but less than 90) is a b, any grade of 70 or more (but less than 80) is a c, any grade of 60 or more (but less than 70) is a d, and any grade below 60 is an f. the program will read in the student’s scores and output the student’s record, which consists of two quiz and two exam scores as well as the student’s average numeric score for the entire course and final letter grade. define and use a structure for the student reco