Help with Database Design
Posted: Wed Feb 04, 2004 8:21 am
I am about to build an application to store search engine statistics for out clients sites but i am unsure on the best way to design my DB.
This is an example of the data that will be stored
That is just for one client, there is about 30 all together. Each month, new stats will be added.
This data will be pulled from the database and displayed in text and graph format.
How is the best way to design this DB? will i need more than one table etc etc?
Thanks
Mark
This is an example of the data that will be stored
Code: Select all
Jan-04 Feb-04
First place rankings 0 0
Top 5 5 0
Top 10 7 7
Top 20 20 12
Top 30 22 20
Moved up 0 4
Moved down 0 14
Same 22 3
Total 22 21
Gain/Loss 0 -10
Visability Percentage 5.18 4.67
Visability Score 337 286This data will be pulled from the database and displayed in text and graph format.
How is the best way to design this DB? will i need more than one table etc etc?
Thanks
Mark