On Mar 16, 10:45 am, "gl" <stin..._at_pd.jaring.my> wrote:
> Hey guys, need expect opinion on table design and access. For a loan
> record which going to store 300 months of principal outstanding and
> interest outstanding. Which is a better choice?
>
> 1) Create a table with data structure as
> loan_no, month_no, prin_os, int_os
>
> 2) create a table with
> loan_no, p_mth1, p_mth2, p_mth3 ... p_mth300.
>
> The first method will have million of records which cause I/O
> contention, the second method will have issue on selecting data
> randomly. Is there any other way for this design? Thank you.
Check this out: http://en.wikipedia.org/wiki/Database_normalization#Normal_forms.
2nd option is addressed under First Normal Form.
Received on Fri Mar 16 2007 - 09:50:33 CDT
