Database design - how to?

[kanakana]

Hi

This is my first post.
I need a help on db designing for one requirement.

1.) For a domain name i will be collecting three statistics every day for one year.

I thought of creating table for a domain name with each column (for each date). These column will point to a table which willl contain three statistics of a day. But i feel that is an inefficient way of doing as the tables will grow up over the years.

Any pointer how can i tackle this requirement.

TIA

[Ancient Dragon]

instead of having a all those columns it should have one row for each date. Only one column contains a date -- and use it as part of the key field. That way your table can have as many dates as you want.