AnsweredAssumed Answered

How many tables to store loosely related categories?

Question asked by wladdy on Oct 11, 2012
Latest reply on Oct 11, 2012 by philmodjunk

Title

How many tables to store loosely related categories?

Post

      

     ‘Cardio’, ‘Classes’ and ‘Workouts’ refer to three types of training sessions.
     They all have a ‘start time’, a ‘length’ and a ‘location’.

     However, they also have very different attributes.
     For instance, ‘Average BPM’, ‘machine’ and ‘pace’ are specific to ‘Cardio’, while ‘Instructor’, ‘Discipline’ and ‘Moves’ is specific to ‘Classes’.
     Furthermore, the details of ‘Workouts’ are contained in ‘Sets’, a linked table with attributes such as ‘Weight’, ‘Reps’, etc.

     I wonder whether I should keep the three training types in only table ‘Sessions’ or keep the three types in its own distinct table?

     Your advice will be greatly appreciated. W.

Outcomes