Re: [GENERAL] Designing tables based on user input and defined values

2016-02-28 Thread Adrian Klaver
On 02/28/2016 09:20 AM, Karsten Hilbert wrote: On Sun, Feb 28, 2016 at 09:09:02AM -0800, Adrian Klaver wrote: I have found that my best design tool is a legal pad and a pencil/pen. http://www.howtomakesenseofanymess.com/ Wow, that is an interesting link. Have just skimmed it at this

Re: [GENERAL] Designing tables based on user input and defined values

2016-02-28 Thread Karsten Hilbert
On Sun, Feb 28, 2016 at 09:09:02AM -0800, Adrian Klaver wrote: > I have found that my best design tool is a legal pad and a pencil/pen. http://www.howtomakesenseofanymess.com/ Karsten Hilbert -- GPG key ID E4071346 @ eu.pool.sks-keyservers.net E167 67FD A291 2BEA 73BD 4537 78B9 A9F9 E4

Re: [GENERAL] Designing tables based on user input and defined values

2016-02-28 Thread Adrian Klaver
On 02/28/2016 06:09 AM, Aaron Christensen wrote: On Sun, Feb 28, 2016 at 12:36 AM, Adrian Klaver mailto:adrian.kla...@aklaver.com>> wrote: On 02/27/2016 09:19 PM, Aaron Christensen wrote: There is somewhat a method to this madness :). There isn't a formula that de

Re: [GENERAL] Designing tables based on user input and defined values

2016-02-28 Thread Aaron Christensen
On Sun, Feb 28, 2016 at 1:15 AM, David G. Johnston < david.g.johns...@gmail.com> wrote: > On Sat, Feb 27, 2016 at 10:36 PM, Adrian Klaver > wrote: > >> On 02/27/2016 09:19 PM, Aaron Christensen wrote: >> >>> There is somewhat a method to this madness :). There isn't a formula >>> that determines

Re: [GENERAL] Designing tables based on user input and defined values

2016-02-28 Thread Aaron Christensen
On Sun, Feb 28, 2016 at 12:36 AM, Adrian Klaver wrote: > On 02/27/2016 09:19 PM, Aaron Christensen wrote: > >> There is somewhat a method to this madness :). There isn't a formula >> that determines outcome. They will just be arbitrary values that I >> assign. >> >> Obviously, I'm new to SQL bu

Re: [GENERAL] Designing tables based on user input and defined values

2016-02-27 Thread David G. Johnston
On Sat, Feb 27, 2016 at 10:36 PM, Adrian Klaver wrote: > On 02/27/2016 09:19 PM, Aaron Christensen wrote: > >> There is somewhat a method to this madness :). There isn't a formula >> that determines outcome. They will just be arbitrary values that I >> assign. >> >> Obviously, I'm new to SQL bu

Re: [GENERAL] Designing tables based on user input and defined values

2016-02-27 Thread Adrian Klaver
On 02/27/2016 09:19 PM, Aaron Christensen wrote: There is somewhat a method to this madness :). There isn't a formula that determines outcome. They will just be arbitrary values that I assign. Obviously, I'm new to SQL but I'm trying to understand your suggestion. It appears that table Final h

Re: [GENERAL] Designing tables based on user input and defined values

2016-02-27 Thread Aaron Christensen
There is somewhat a method to this madness :). There isn't a formula that determines outcome. They will just be arbitrary values that I assign. Obviously, I'm new to SQL but I'm trying to understand your suggestion. It appears that table Final has the composite/primary keys of goal and size whic

Re: [GENERAL] Designing tables based on user input and defined values

2016-02-27 Thread Adrian Klaver
On 02/27/2016 03:12 PM, Aaron Christensen wrote: Hi Adrian, Thank you for responding with the SQL code. However, outcome cannot be a primary key because outcome values will be duplicates in some instances. I am not sure how else to have a lookup table that stores static values. Well first is

Re: [GENERAL] Designing tables based on user input and defined values

2016-02-27 Thread Aaron Christensen
Hi Adrian, Thank you for responding with the SQL code. However, outcome cannot be a primary key because outcome values will be duplicates in some instances. I am not sure how else to have a lookup table that stores static values. Thanks! Aaron On Sat, Feb 27, 2016 at 5:15 PM, Adrian Klaver wr

Re: [GENERAL] Designing tables based on user input and defined values

2016-02-27 Thread Adrian Klaver
On 02/27/2016 01:15 PM, Aaron Christensen wrote: Hello, I am trying to figure out the correct way to design the database table to support the following situation. To start, I have an Excel spreadsheet that maps particular combinations of Goal and Size to an Outcome. Goal choices are "Long", "A

[GENERAL] Designing tables based on user input and defined values

2016-02-27 Thread Aaron Christensen
Hello, I am trying to figure out the correct way to design the database table to support the following situation. To start, I have an Excel spreadsheet that maps particular combinations of Goal and Size to an Outcome. Goal choices are "Long", "Average", and "Short". Size choices are "Big", "Med