[SOLVED] mysql repeat data

[Locked]

Hi i have looked at database normalization but what i cant desicde where do i stop with not having repeat data and having each feild in its own table?

 

Like say i have a feild in the users table for fsig (forum signature), not everyone is going to have one so should there be another table with

fsig,psig and msig (Forum, profile and mail) and assign a userid (related to the users table) to that table or just have the 3 feilds in the user table?

 

Thats just an example, was wondering if their is a general rule or what not.

[teng84]

this is not php this is sql this should be on mysql board ..

 

anyways sample..

 

member                  member_fruit                    fruits

 

myid +-----------<    member_id              +--+  fruits_id

name                      fruit_id>-------------        name

lastname                                                        price

address                                                        etc

etc.. 

 

in that sample you dont need to enter repeated members info just    to show his/her favorites fruit