Ygthkb

Does the Holy Ark weigh 4 tons?

How can a kingdom keep the secret of a missing monarch from the public?

Can a Hydra make multiple opportunity attacks at once?

Why is airport car rental so cheap

Was the Soviet N1 really capable of sending 9.6 GB/s of telemetry?

Translation for threshold (figuratively)

Can I use the LastResort font in a web page?

Build ASCII Podiums

How do I split ammo?

Did the characters in Moving Pictures not know about cameras like Twoflower's?

Why do we interpret the accelerated expansion of the universe as the proof for the existence of dark energy?

How can guns be countered by melee combat without raw-ability or exceptional explanations?

How to play songs that contain one guitar when we have two or more guitarists?

How many copper coins fit inside a cubic foot?

Can I combine Divination spells with Arcane Eye?

Are there any spells or magic items that allow for making of ‘logic gates or wires’?

Why write a book when there's a movie in my head?

What does an unprocessed RAW file look like?

Buying a "Used" Router

Have any astronauts or cosmonauts died in space?

Is it possible to detect 100% of SQLi with a simple regex?

Counting primes in a range whose digits are all prime

How can changes in personality/values of a person who turned into a vampire be explained?

Last Reboot commands don't agree

Designing a tracking system for ordered workouts

Designing An ACL Based Permission SystemDatabase Designing IssueDesigning a reservation system schemaCreating and designing Air Trafic Control SystemDesigning a SQL database for a Tire Purchase SystemUser based payment system table designingDesigning an extensible authentication systemDesigning a database structure for a permissions systemOne generic mapping table VS many specific mapping tablesDesigning a message system

2

I've taken a handful of introductory database courses, so I thought I'd design a relational database to help me keep track of my workout routines. It turned out to be a more difficult task than I'd anticipated.

So say I record my workout session with a pen and paper something like this:

Monday

 1. jogging | 1.5 miles

 2. plank   | 3 minutes

 3. lift_A  | 5 pounds  | 15 reps

 4. lift_A  | 5 pounds  | 15 reps

 5. lift_A  | 6 pounds  | 17 reps

Tuesday

 1. plank    | 3 minutes | 3 pounds

 2. wall sit | 2 minutes

 3. jogging  | 1.6 miles

 4. lift_B   | 10 pounds | 2 reps

I need to keep track of the date of each series of exercises as well as the order I do them in. I had trouble figuring out how best to store the three "types" of activities (distance, duration w/ optional weight, weight+reps) and how to manage their recorded order in a day's workout.

How can I design a database (with or without an entity-relationship diagram, which would be nice) to help me record such information? What is the most logical/intuitive approach? Is a relational database even an appropriate approach at all?

database-design

share|improve this question

edited 8 mins ago

MDCCL

6,76931745

asked Nov 4 '16 at 23:17

fizix00fizix00

133

add a comment | 

2

I've taken a handful of introductory database courses, so I thought I'd design a relational database to help me keep track of my workout routines. It turned out to be a more difficult task than I'd anticipated.

So say I record my workout session with a pen and paper something like this:

Monday

 1. jogging | 1.5 miles

 2. plank   | 3 minutes

 3. lift_A  | 5 pounds  | 15 reps

 4. lift_A  | 5 pounds  | 15 reps

 5. lift_A  | 6 pounds  | 17 reps

Tuesday

 1. plank    | 3 minutes | 3 pounds

 2. wall sit | 2 minutes

 3. jogging  | 1.6 miles

 4. lift_B   | 10 pounds | 2 reps

I need to keep track of the date of each series of exercises as well as the order I do them in. I had trouble figuring out how best to store the three "types" of activities (distance, duration w/ optional weight, weight+reps) and how to manage their recorded order in a day's workout.

How can I design a database (with or without an entity-relationship diagram, which would be nice) to help me record such information? What is the most logical/intuitive approach? Is a relational database even an appropriate approach at all?

database-design

share|improve this question

edited 8 mins ago

MDCCL

6,76931745

asked Nov 4 '16 at 23:17

fizix00fizix00

133

add a comment | 

I've taken a handful of introductory database courses, so I thought I'd design a relational database to help me keep track of my workout routines. It turned out to be a more difficult task than I'd anticipated.

So say I record my workout session with a pen and paper something like this:

Monday

 1. jogging | 1.5 miles

 2. plank   | 3 minutes

 3. lift_A  | 5 pounds  | 15 reps

 4. lift_A  | 5 pounds  | 15 reps

 5. lift_A  | 6 pounds  | 17 reps

Tuesday

 1. plank    | 3 minutes | 3 pounds

 2. wall sit | 2 minutes

 3. jogging  | 1.6 miles

 4. lift_B   | 10 pounds | 2 reps

I need to keep track of the date of each series of exercises as well as the order I do them in. I had trouble figuring out how best to store the three "types" of activities (distance, duration w/ optional weight, weight+reps) and how to manage their recorded order in a day's workout.

How can I design a database (with or without an entity-relationship diagram, which would be nice) to help me record such information? What is the most logical/intuitive approach? Is a relational database even an appropriate approach at all?

database-design

share|improve this question

edited 8 mins ago

MDCCL

6,76931745

asked Nov 4 '16 at 23:17

fizix00fizix00

133

 1. jogging | 1.5 miles

 2. plank   | 3 minutes

 3. lift_A  | 5 pounds  | 15 reps

 4. lift_A  | 5 pounds  | 15 reps

 5. lift_A  | 6 pounds  | 17 reps

 1. plank    | 3 minutes | 3 pounds

 2. wall sit | 2 minutes

 3. jogging  | 1.6 miles

 4. lift_B   | 10 pounds | 2 reps

share|improve this question

edited 8 mins ago

MDCCL

6,76931745

asked Nov 4 '16 at 23:17

fizix00fizix00

133

share|improve this question

edited 8 mins ago

MDCCL

6,76931745

asked Nov 4 '16 at 23:17

fizix00fizix00

133

edited 8 mins ago

MDCCL

6,76931745

edited 8 mins ago

MDCCL

6,76931745

asked Nov 4 '16 at 23:17

fizix00fizix00

133

asked Nov 4 '16 at 23:17

fizix00fizix00

133

1 Answer
1

active

oldest

votes

0

Well, there's a simple 1 table solution right here:

| exercise_type (not null) | amount (not null) | other_field (null) | date (not null) | 

To get the exercises for a particular date, you'd run a simple select statement (psuedo code):

select * from exercises where date in between (start, finish)

And you can refine to particular exercise types by adding:

and exercise_type = 'plank'

share|improve this answer

answered Nov 5 '16 at 0:01

James111James111

1808

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  How does this solution keep track of the order in which the exercises were performed on a certain date?
  
  – fizix00
  Nov 5 '16 at 1:41
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  You record the time of each exercise. You simple order by the date @fizix00
  
  – James111
  Nov 5 '16 at 1:43
  

  
  
  
  

add a comment | 

Your Answer

StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "182"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);

StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});

function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: false,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: null,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});


}
});

draft saved

draft discarded

Sign up or log in

StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});

Sign up using Google

Sign up using Facebook

Sign up using Email and Password

Post as a guest

Name

Email

Required, but never shown

StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fdba.stackexchange.com%2fquestions%2f154315%2fdesigning-a-tracking-system-for-ordered-workouts%23new-answer', 'question_page');
}
);

Post as a guest

Name

Email

Required, but never shown

0

Well, there's a simple 1 table solution right here:

| exercise_type (not null) | amount (not null) | other_field (null) | date (not null) | 

To get the exercises for a particular date, you'd run a simple select statement (psuedo code):

select * from exercises where date in between (start, finish)

And you can refine to particular exercise types by adding:

and exercise_type = 'plank'

share|improve this answer

answered Nov 5 '16 at 0:01

James111James111

1808

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  How does this solution keep track of the order in which the exercises were performed on a certain date?
  
  – fizix00
  Nov 5 '16 at 1:41
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  You record the time of each exercise. You simple order by the date @fizix00
  
  – James111
  Nov 5 '16 at 1:43
  

  
  
  
  

add a comment | 

0

Well, there's a simple 1 table solution right here:

| exercise_type (not null) | amount (not null) | other_field (null) | date (not null) | 

To get the exercises for a particular date, you'd run a simple select statement (psuedo code):

select * from exercises where date in between (start, finish)

And you can refine to particular exercise types by adding:

and exercise_type = 'plank'

share|improve this answer

answered Nov 5 '16 at 0:01

James111James111

1808

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  How does this solution keep track of the order in which the exercises were performed on a certain date?
  
  – fizix00
  Nov 5 '16 at 1:41
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  You record the time of each exercise. You simple order by the date @fizix00
  
  – James111
  Nov 5 '16 at 1:43
  

  
  
  
  

add a comment | 

Well, there's a simple 1 table solution right here:

| exercise_type (not null) | amount (not null) | other_field (null) | date (not null) | 

To get the exercises for a particular date, you'd run a simple select statement (psuedo code):

select * from exercises where date in between (start, finish)

And you can refine to particular exercise types by adding:

and exercise_type = 'plank'

share|improve this answer

answered Nov 5 '16 at 0:01

James111James111

1808

| exercise_type (not null) | amount (not null) | other_field (null) | date (not null) | 

select * from exercises where date in between (start, finish)

and exercise_type = 'plank'

share|improve this answer

answered Nov 5 '16 at 0:01

James111James111

1808

answered Nov 5 '16 at 0:01

James111James111

1808

answered Nov 5 '16 at 0:01

James111James111

1808