mysql database structure

[alin19]

i want to design a data base and i don't have exprerience, i don't want later to find out that it was wrong from the start;

 

so i ask for you're openion,

 

 

ion                  south market        volume      price    21.01.2008

gheorghe          north market          volume      price    28.12.2007

lisa                  east market          volume      price    21.01.2008 

 

 

i have a lot of line like this, i need to insert them into a database with tables and line,

 

table: ion

        gheorghe

 

or

 

table:    east market

            north market

or date:

 

          18.01.2008

          19.01.2008

 

ion, gheorhge and lisa    can sell in all markets in any day,

 

 

markets are just a dozen, but names and days are a lot,

 

and later a may need to make a grafic with the sells,

 

what is the size that a database in working slow?

 

 

[adam291086]

You need to look into normilastion.

 

Follow the steps and that will give you your table structure.