[SOLVED] 50 fields using joins

[stuart7398]

Hi.

my database will have around 50 fields.

3 will be for 3 x images

1 will be a 300 word description

the rest will be things like 'name' 'color'

 

what is the best way to set this databse up?

one table with many fields

or

seperate tables

 

and would i use 'Joins' to connect the tables?

 

i'm trying to keep it as simple as possible.

 

your input and suggestions are apprecaited.

 

Thanks,

Stuart.

[aschk]

Sounds like you want a 101 in normalisation. I doubt very much that all that information will belong in 1 table. Google database normalisation and you're onto a winner...