Re: Need help accessing the key array. [message #185453 is a reply to message #185452] |
Tue, 01 April 2014 01:09 |
Jerry Stuckle
Messages: 2598 Registered: September 2010
Karma:
|
Senior Member |
|
|
On 3/31/2014 8:55 PM, Denis McMahon wrote:
> On Mon, 31 Mar 2014 07:37:19 -0400, Jerry Stuckle wrote:
>
>> I see no need for arrays or json objects in a database here. Or a graph
>> database, for that matter.
>
> Agreed. A table with three elements per row, namely animal, colour, rate,
> keyed on the combination of animal and colour.
>
> Or possible 3 tables:
>
> animals: animal_name* | animal_id
>
> colours: colour* | colour_id
>
> rates: animal_id* | colour_id* | rate
>
> Where * indicates the field(s) that make the PK for the table, but I
> suspect that's overkill for the task as described so far.
>
Looks like a good design to me, Denis. :)
--
==================
Remove the "x" from my email address
Jerry Stuckle
jstucklex(at)attglobal(dot)net
==================
|
|
|