I need some idea about my database design. I have about 5 fields for basic information of user, such as name, email, gender etc. Then I want to have about 5 fields for optional information such as messenger id's. And 1 optional text field for info about user. Should i create only one tabel with all fields all together or i should create separate table for the 5 optional fields in order to avoid redundancy etc? Thanks.
I'll stick with only one table.
Adding another table would only makes thins more complicated and you will only gain really little disk space.
And I really don't see how this can be redundant in any way ;)