Hi...
I am getting grey hair...i don't now the right setup for the solution. Maybe you can help?..
Concept.
companyX has for each period (1 year, 2 years ect) different 5 values....
So for example: 2 years...has the value rates of 3%, 4%, 6%, 7% 5 years...has the value rates of 4%, 6%, 6%, 9%
Can anyone help how my table scheme looks like...or multiply tables??
remco
Hi...
I am getting grey hair...i don't now the right setup for the solution. Maybe you can help?..
Concept.
companyX has for each period (1 year, 2 years ect) different 5 values....
when I hear "five values" I think "five fields". Or, in ruby, five attr_accessors, or five instance variable.
I think of the periods as either records or rows, or, in ruby: objects (if that helps).
So for example: 2 years...has the value rates of 3%, 4%, 6%, 7% 5 years...has the value rates of 4%, 6%, 6%, 9%
That's the desired output? It's not meaningful to me; I have no idea what that's supposed to convey. Do you want:
2 years rates in percentages : 3,4,6,5 5 years rates in percentages : 4,6,6,9
If so, why? What does it mean? A five year loan at four percent? or six percent? Which one?
Can anyone help how my table scheme looks like...or multiply tables??
remco
table: quarters
year quarter 2007 1 2007 2 ...
table: rates
rate 3 5 5 6
one-to-many relation between "quarters" and "rates" so that query results are along the lines of:
year quarter rate 2007 1 3 2007 1 4 2007 2 5
However, that doesn't make sense to me because *why* would there be:
2007 quarter 1 3% rate 2007 quarter 1 4% rate
Also, it's kind of silly to have a "rates" table which just has a list of integers, but the alternative is to put the year and quarter into one field giving:
year & quarter rate
[...]
Example, check > http://www.renteoverzicht.nl/hypotheekrenteoverzicht.php
[...]
table: five year
lender NHG rate1 rate2 rate3 rate4