Suppose you are designing a database to track your exercise sessions and progress toward your fitness goals. At a minimum, you will need to record the details of each session and be able to report on your activity over a specific range of dates. You’ll probably want the database to supply information for charts to show your progress and the increasing intensity of your workouts.
Write to the following discussion topic, touching on each of the bulleted questions:
Assuming you want to record changes in your weight, would you do this in a separate table or would you record it for each workout?
How would you design the tables to record separate activities where those like running might be based on time or distance and others such as weight training based on repetitions?
Would you record the number of calories burned during each activity in the tables or just record enough information so that the software can calculate it later? (This figure can be calculated based on factors such as the activity and your current weight. The complexity of the calculation as factors change over time might cause whatever program was using the data to take longer to generate the reports).