You have decided to start lifting weights at the gym. You would like to track your progress on each exercise. To make it easier to enter data, you are designing an application based on the day of exercise that enables you to enter additional information such as your weight, time, health (excellent, good, tired, weak, sick), and general comments. For most weight-lifting exercises, you perform multiple lifts (repetitions) within a set, then change the weight for a new set and do another set of repetitions. Design a normalized database for tracking your exercises. Date: Weight: Comments Total time: Exercise Weight/set # Reps Comments
Please show your work as well as primary and foreign keys.