Re: Database/Table Design for Global Country Statistics

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

On 09/12/07 03:28, Stefan Schwarzer wrote:
[snip]
>
> The new design would be like this:
>
> id   |    year    |    value
> -------------------------------
>  1   |   1970    |     NULL
>  1   |   1971    |      36
>  1   ....
>  1   |   2005    |      45
>  2   |   1970    |      ....
>  2   .....
>
>
> Would that be considered as "good table design" then?

What Richard says, plus:

1. The PK of New_Design should be country_id/year.

2. You also should not store the records where "value is NULL".  A
left outer join would handle that.

- --
Ron Johnson, Jr.
Jefferson LA  USA

Give a man a fish, and he eats for a day.
Hit him with a fish, and he goes away for good!

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.6 (GNU/Linux)

iD8DBQFG57E/S9HxQb37XmcRAsb/AJ97lFt25sLwIYhkhQgGdJq2m8NaXgCfTxIV
rVuX5FF0XRDkXJgdSlV1qZg=
=jyv3
-----END PGP SIGNATURE-----